"The activity of choosing an efficient execution strategy for processing a query is called as Query optimization." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)
[automatic query optimization:] "A method by which a DBMS takes care of finding the most efficient access path for the execution of a query." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management 9th Ed", 2011)
[dynamic query optimization:] "Refers to the process of determining the SQL access strategy at run time, using the most up-to-date information about the database. Contrast with static query optimization." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed, 2011)
[static query optimization:] "A query optimization mode in which the access path to a database is predetermined at compilation time. Contrast with dynamic query optimization." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)
"The overall process of choosing the most efficient means of executing a SQL statement." (Oracle, "Database SQL Tuning Guide Glossary", 2013)
[adaptive query optimization:] "A set of capabilities that enables the adaptive optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better statistics. Adaptive optimization is helpful when existing statistics are not sufficient to generate an optimal plan." (Oracle, "Database SQL Tuning Guide Glossary", 2013)
"Query optimization determine the most efficient way to execute a given query by considering possible query plans. Indexes and materialized views are also part of this approach." (Piethein Strengholt, "Data Management at Scale", 2020)
No comments:
Post a Comment