Learn the vocabulary of an index that answers a query directly without touching the table row.
0 / 5 completed
1 / 5
At standup, a dev mentions building an index that includes every column a query actually needs, so the database can answer that query directly from the index without touching the underlying table row. What is this kind of index called?
A covering index includes every column a query actually needs, so the database can answer that query directly from the index without ever touching the underlying table row. A minimal index containing only the filter column still requires a separate lookup into the table for every other column the query selects. This complete coverage is what lets a covering index eliminate an otherwise necessary extra row fetch entirely.
2 / 5
During a design review, the team wants to add a non-filtered, non-sorted column to the index purely so it can be read directly from the index, without making that column part of the index's actual sort key. Which capability supports this?
INCLUDE columns add data to a covering index purely so it can be read directly from the index, without making that column part of the index's actual sort key or search structure. Adding every additional column directly into the sort key would bloat and complicate the index's ordering unnecessarily. This INCLUDE mechanism is what lets an index cover a query's needed columns efficiently without disturbing its core, indexed ordering.
3 / 5
In a code review, a dev notices avoiding a 'bookmark lookup', where the database has to jump back to the actual table row to fetch a column not present in the index, by widening the index to include that missing column. What does this represent?
Eliminating a bookmark lookup by widening the index to cover every needed column avoids the extra jump back to the actual table row that would otherwise be required to fetch a missing column. Always performing that lookup regardless wastes an avoidable, extra round trip for every single query execution. This widening is exactly what defines the difference between a regular index and a genuinely covering one.
4 / 5
An incident report shows a frequently run query was still hitting the base table for one extra column not included in the existing index, causing a large number of unnecessary row lookups despite an index already existing on the filter column. What practice would prevent this?
Widening the existing index to include every column the query actually selects turns it into a covering index, eliminating the extra row lookup this incident describes. Leaving the index limited to only the filter column forces exactly that unnecessary extra lookup for every execution of the query. This widening is a common, high-impact optimization once a frequently run query's full column needs are identified.
5 / 5
During a PR review, a teammate asks why the team builds a covering index instead of a regular index on just the filter column, when the regular index already speeds up finding the matching rows. What is the reasoning?
A regular index on just the filter column speeds up finding the matching rows but still requires an extra lookup back to the table for any other column the query actually selects. A covering index eliminates that lookup entirely by including every needed column directly in the index itself. The tradeoff is a larger index that takes up more storage and costs slightly more to maintain on every write.
What does the "Covering Indexes Vocabulary" vocabulary exercise cover?
This exercise tests real IT vocabulary related to covering indexes vocabulary through 5 multiple-choice questions, each built from realistic workplace sentences rather than abstract definitions.
Is this vocabulary exercise free to use?
Yes. Every exercise on CoderSlingo, including this one, is completely free — no account, sign-up, or payment required.
How many questions does this exercise have?
This exercise has 5 questions. Each one shows a real-world sentence or scenario with multiple-choice options and an explanation once you answer.
What happens after I answer a question?
You'll see immediate feedback showing whether your answer was correct, along with a short explanation of why — then a button to move to the next question, and a full results screen at the end.
Can I retry the exercise if I get questions wrong?
Yes. Once you reach the results screen, click "Try again" to reset your answers and go through the exercise from the start as many times as you like.
Do I need to create an account to take this exercise?
No account is needed. Your answers are scored in your browser during the session — nothing is saved to a server, so you can jump straight in.
Is my progress saved if I leave the page?
No — progress within an exercise resets if you navigate away or reload. Each exercise is short enough to complete in a few minutes in one sitting.
Are these vocabulary exercises connected to other topics?
Yes — this module shares real-world context with 9 other vocabulary modules. See "Related vocabulary" below to keep building a connected skill set.
How is this different from reading a glossary or blog article?
Exercises like this one are active recall drills — you have to choose the correct term or phrasing yourself, which builds retention faster than passively reading a definition.
Where can I find more vocabulary exercises?
Browse the full Vocabulary exercises hub for hundreds of modules covering Agile, DevOps, security, databases, architecture, and more — organised by IT role and skill.