System and Object Statistics


System and object statistics are essential because they describe both the system running the database engine and the data stored in the database. In fact, a query optimizer that is aware of only the SQL statement to be processed and the structure of the objects referenced by the SQL statement is not able to provide efficient execution plans. Simply put, it has to be able to quantify the amount of data to be processed.


Object Statistic Query Optimizer Data Dictionary Column Statistic Database Engine 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Christian Antognini 2008

Personalised recommendations