#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')

Μόνο CREATE/ALTER/DROP — δεν χρειάζεται τελικό SELECT.

Το αποτέλεσμα του ερωτήματός σας θα εμφανιστεί εδώ