-- Partial index for active reservations (most common query)
CREATE INDEX CONCURRENTLY IF NOT EXISTS reservation_active_idx
  ON "Reservation" (date, time)
  WHERE status IN ('PENDING', 'CONFIRMED');
