SQL Arena
#1006

Faster Paid Orders

The paid-orders list in orders is built from status = 'paid' and currently reads too much data. Add an index on status so this screen finds the needed rows faster.

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

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

Sign in to submit

Your query result will appear here