In this chapter we will cover:
By now, we have already learnt about the index in Chapter 9, Implementing Indexes, and Chapter 10, Maintaining Indexes. The optimizer chooses the index for a query if there are proper and updated statistics available for key columns of the index, because the SQL Server optimizer is a cost-based optimizer. An optimizer can decide the best way to execute the query, based on the data going to be displayed in result sets with the help of column(s) used in the
ON clauses. The optimizer ...