John Caius

-- Composite index for common filter + sort
CREATE INDEX idx_orders_user_date
  ON orders (user_id, created_at DESC);

-- Partial index (only active records)