Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

10.3 Physical Query Optimization

The next step in optimization is for the strategy selector to choose an execution plan. To develop an execution plan, the strategy selector must consider the various ways each of the operations in the query tree could be executed. It “prices” each method by considering the costs of the processes involved.

10.3.1 Cost Factors

The cost of executing a query is determined by the cost of reading files, the processing costs once data is in main memory, the cost of writing and storing any intermediate results, the communication costs, and the cost of writing the final results to storage. Of these, the most significant factor is the number of data accesses—the read and write costs. In calculating these costs, the DBMS ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595