root
6 lines
165 B
SQL
6 lines
165 B
SQL
CREATE INDEX "bottles_pick_candidates_id_idx"
|
|
ON "bottles"("id")
|
|
WHERE "review_status" = 'APPROVED'
|
|
AND "pool_status" = 'IN_POOL'
|
|
AND "active_lease_id" IS NULL;
|