SQL Arena
#1012

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'

Samo CREATE/ALTER/DROP — zaključni SELECT ni potreben.

Prijavite se za oddajo

Rezultat vaše poizvedbe se bo prikazal tukaj