covering index

noun

Definitions

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

The neighborhood

Vish — recursive loop

No curated loop yet for covering index. Loops are being traced one word at a time while the ingestion pipeline matures.

sense glosses and etymology drawn from English Wiktionary · source · CC-BY-SA