-- IF NOT EXISTS: this index was already created on the live DB on 2026-07-02
-- (CREATE INDEX CONCURRENTLY, outside the migration flow) to unblock a plan
-- cleanup; there this migration must no-op. Fresh environments build it here.
CREATE INDEX IF NOT EXISTS "idx_plan_recommendations_recommendation_id" ON "plan_recommendations" USING btree ("recommendation_id");