SQL Server Performance

SQL Server Statistics

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, May 16, 2008.

  1. Anonymous New Member

    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">

Share This Page