SQL Arena
#981

Dashboard Status Lookup

The dashboard often shows orders whose status is paid or pending, but lookups by status are too slow. Add an index on status so this list opens faster.

Speed this query up with an index
SELECT * FROM orders WHERE status IN ('paid','pending')

Just CREATE/ALTER/DROP — no trailing SELECT needed.

Sign in to submit

Your query result will appear here