12. Using the Query Optimizer : Database Statistics
 
Share this page                  
Database Statistics
Generating statistics for a database optimizes it, which affects the speed of query processing. More complete and accurate statistics generally result in more efficient query execution strategies, which further result in faster system performance.
The extent of the statistics to be generated for a database can be modified by various options, including restricting the tables and columns that are used.
Note:  Deleting all the rows in a table does not delete the statistics.