covering index
nounDefinitions
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