Definitions for "Covering Index" Add To Word List
Login or Register  | Word Lists | Search History

a form of a composite index
Helpful?           0
an index that includes all the columns that are referenced in the WHERE and SELECT clauses
Helpful?           0
an index, which includes all of the columns referenced in the query
Helpful?           0
a nonclustered index that contains ALL the columns referenced in any clause of a query
Helpful?           0
a non-clustered index that contains all the information requested by the user in the index's leaf level (including the key and the pointer)
Helpful?           0
a nonclustered index that is built upon all of the columns required to satisfy an SQL query, both in the selection criteria and the WHERE predicate
Helpful?           0