Index Strategies

When Indexes Help

Indexes speed up WHERE, JOIN, and ORDER BY but slow down writes. Add them on columns you filter or sort by frequently.

CREATE INDEX idx_orders_customer ON orders(customer_id);
CREATE INDEX idx_orders_created  ON orders(created_at DESC);