Why Is My Index Ignored?

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

There's an index on the email column, yet a query that searches by lower-cased email, and another that searches for emails containing a word, both scan the whole table. Explain why, and how you'd fix each.

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 →