solulubeta
Sign in
SQL / Changing data & structure
07.08 · SQL

Speeding up date lookups

Looking up a day's sales is the most common query at the counter. Create an index on sales(sale_date), then return all columns of the sales made on 9 March 2024.

Hard 3 min Pro

This lesson is part of solulu Pro

Looking up a day's sales is the most common query at the counter. Create an index on sales(sale_date), then return all columns of the sales made on 9 March 2024.

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 74 of 77 · updated 2026-10-12