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

SQL Hard
Select the correct answer: Single Choice

Key points

  • Covering index includes all query columns
  • Query can be satisfied from index alone
  • Eliminates key lookups for efficiency

Ready to go further?