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.