Index and Statistics
Index and Statistics Introductions Microsoft SQL Server collects statistical information related to 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. If we understand the index statistics in better way, …