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.

Start free →