Covering Indexes with Included Columns

When creating non-clustered index there is a option for including columns to extend its functionality: With including other columns we can create non-clustered indexes that cover more queries.Included columns can be: datatypes not allowed as a index key not considered by the Database Engine when calculating the number of index key columns or index key size Included columns are … Continue reading Covering Indexes with Included Columns