covering index

English

Noun

covering index (plural covering indexes)

  1. (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

Translations
This article is issued from Wiktionary. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.