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 IF NOT EXISTS idx_orders_customer ON orders(customer_id);
CREATE INDEX IF NOT EXISTS idx_orders_created  ON orders(created_at DESC);