Covering Index

Difficulty: Advanced

Question

What is a Covering Index?

Answer

An index that contains all the columns needed for a query. The database can find the answer entirely within the index leaf nodes without fetching the actual rows from the table!

Concepts covered

Performance, Indexing