O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

11.5. Query Optimization

The primary goal of query optimiser is of choosing an efficient execution strategy for processing a query. The query optimiser attempts to minimise the use of certain resources (mainly the number of I/Os and CPU time) by choosing the best of a set of alternative query access plans. Query optimization starts during the validation phase by the system to validate whether the user has appropriate privileges. Existing statistics for the tables and columns are located, such as how many rows (tuples) exist in the table and relevant indexes are found with their own applicable statistics. Now an access plan is generated to perform the query. The access plan is then put into effect with the execution plan of generated during query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required