Hello, you have come here looking for the meaning of the word
covering index. In DICTIOUS you will not only get to know all the dictionary meanings for the word
covering index, but we will also tell you about its etymology, its characteristics and you will know how to say
covering index in singular and plural. Everything you need to know about the word
covering index you have here. The definition of the word
covering index will help you to be more precise and correct when speaking or writing your texts. Knowing the definition of
covering index, as well as those of other words, enriches your vocabulary and provides you with more and better linguistic resources.
English
Noun
covering index (plural covering indexes)
- (databases) A database table index that contains all the columns needed to fulfill the query.
2003, Peter Gulutzan, Trudy Pelzer, SQL Performance Tuning, Addison-Wesley Professional, →ISBN, page 232: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.
Translations