3 ms·
A single multi-column index would only work for the one specific query in the example. We have many queries that contain filters that are not easy to index such
by malisper 9y ago
A single multi-column index would only work for the one specific query in the example. We have many queries that contain filters that are not easy to index such as regular expression filters. Additionally, a multi-column index would be significantly larger than the corresponding partial index.