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.
KeywordsObject Statistic Query Optimizer Data Dictionary Column Statistic Database Engine
Unable to display preview. Download preview PDF.