Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

SQL Server 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. Microsoft has released a whitepaper that describes what data is collected where it is stored, and which commands create, updates, and delete statistics

More