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')Doar CREATE/ALTER/DROP — nu este nevoie de un SELECT la final.
Conectează-te pentru a vedea istoricul soluțiilor trimise
Conectează-teConectează-te pentru a folosi Mentorul AI
Conectează-te