By now, you should have a good understanding of the importance of indexes. It is equally important for the optimizer to have the necessary statistics on the data distribution so that it can choose indexes effectively. In SQL Server, this information is maintained in the form of statistics on the index key.
KeywordsComposite Index Execution Plan Query Optimizer Manual Maintenance Automatic Statistic
Unable to display preview. Download preview PDF.