Rare Cancelled Orders
Support often searches for cancelled orders, and rows with status = 'cancelled' are rare. Create a compact partial index on status that stores only those rows from orders.
Speed this query up with an index
SELECT * FROM orders WHERE status = 'cancelled'
Iba CREATE/ALTER/DROP — žiadny záverečný SELECT nie je potrebný.
Prihláste sa, aby ste videli históriu odoslaní
Prihlásiť saPrihláste sa, aby ste mohli používať AI mentora
Prihlásiť sa