Databases
Covering index
An index containing every column a query needs, so the engine never reads the table itself.
Why interviewers ask about it
EXPLAIN shows 'Using index'. The lookup back to the row is often the expensive part, so eliminating it is a bigger win than it sounds.
Related terms
This term is part of the free Python Full-Stack interview preparation module - browse the full glossary for every definition.