-- migrations/2026_01_06_recommendation_cover.sql

CREATE INDEX CONCURRENTLY idx_recommendation_active_cover
ON recommendation (
  id,
  property_id,
  measure_type,
  type
)
INCLUDE (estimated_cost)
WHERE default = true
  AND already_installed = false;
