Articles → SQL SERVER → Covering index in SQL server
Covering index in SQL server
Technical knowledge
Non-clustered index and key loop ups
Column Name | Data Type |
Id | int |
Title | varchar(300) |
Deadline | Date |
Assigned To | varchar(100) |
Click to Enlarge
select Title from Task where Title = 'Task 1'
Click to Enlarge
select Title, Deadline from Task where Title = 'Task 1'
Click to Enlarge
Covering index
CREATE NONCLUSTERED INDEX non_clustered_index_name ON table_name(column_name) include (list_of_included_columns)
CREATE NONCLUSTERED INDEX ix_Title ON Task(Title) include (Deadline)
Click to Enlarge