SQL Server collects and maintains statistical information about indexes and column data stored in the database.
SQL Server query optimizer relies on these statistics to choose the most efficient plan for retrieving or updating data. If these statistics are not up-to-date, performance of your queries could be adversely affected.
This whitepaper provides great insights into the world of statistics and how they are used by SQL Server 2005.
You will learn:
You can download this whitepaper from here.
POSTED BY : Sanchan Saxena