SQL Server Statistics

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow the optimizer to accurately assess the cost of different query plans, and choose a high-quality plan. All information about a single statistics object is stored in several columns of a single row in the sysindexes table, and in a statistics binary large...(<a href="http://blogs.technet.com/rob/archive/2008/05/16/sql-server-statistics.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4299" width="1" height="1">