SQL Arena
#1084

Faster Order Status Filter

The orders admin often opens orders filtered to status = 'pending', and that screen is slow. Add an index on status so status-based lookups can find the needed orders faster.

Speed this query up with an index
SELECT * FROM orders WHERE status = 'pending'

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

Sign in to submit

Your query result will appear here