21 ms·
Yep, you could indeed use a partial index with the two relevant conditions to solve this query well. We're using those all over the place as well.
by cube2222 5y ago
Yep, you could indeed use a partial index with the two relevant conditions to solve this query well. We're using those all over the place as well.