Covering Indexes

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • medium
  • Pro

A frequently run query looks up orders by customer and only needs the date and total, but it's still slower than you'd like even with an index on customer. Explain what a covering index is and how it could help.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →