db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Redundant index

An index on (a, b) already serves every search on a alone. A second index on just (a) costs write time and space and adds nothing.

task

orders has three indexes. ix_orders_cust is a prefix of ix_orders_cust_placed; drop the redundant one and keep the other two.

hints