Composite Index Column Order
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
You add an index on two columns of an orders table: customer ID first, then created date. Explain which queries can use it, which can't, and how you'd decide the column order.
Talk this problem through with an AI coach
This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.