medium10 pts · first answer countsdatabase-indexingsql

Composite index column order

A table has a B-tree index on (country, city). Which query can NOT use this index efficiently for its filter?

A.WHERE country = 'IN'B.WHERE country = 'IN' AND city = 'Pune'C.WHERE city = 'Pune'D.WHERE country = 'IN' ORDER BY city