What is a covering index and how does it eliminate key lookups?

Question

SQL Fundamentals — Hard

What is a covering index and how does it eliminate key lookups?

Accepted Answer

A covering index is an index that includes all columns needed by a query, allowing the engine to fulfill the query solely from the index without accessing the table heap. This eliminates the need for additional key lookups.