medium10 pts · first answer countsindexingquery-tuning

Composite index column order

You create an index on orders(customer_id, created_at). Which query can use this index most efficiently?

A.SELECT * FROM orders WHERE created_at > '2026-01-01'B.SELECT * FROM orders WHERE status = 1C.SELECT * FROM orders WHERE customer_id = 42 AND created_at > '2026-01-01' ORDER BY created_atD.SELECT * FROM orders ORDER BY customer_id DESC, created_at ASC

Discussion 0

Join free to post in the discussion.

Composite index column order

Discussion 0

Related questions