covering index en · NOUN
Meanings
-
A database table index that contains all the columns needed to fulfill the query.
Ordinarily, using a covering index will save one disk read (GAIN: 6/8). The gain is automatic but only if the columns in the select list exactly match the columns in the covering index.
2003, Peter Gulutzan, Trudy Pelzer, SQL Performance Tuning, Addison-Wesley Professional, →ISBN, page 232:
Forms
| Spelling | Features | Labels | Source |
|---|---|---|---|
| covering indexes | Number=Plur | lexicographic |
Translations (1)
fr index couvrant (Translations)