3 ms·
Partial indexes solve exactly this problem. You add a WHERE condition that restricts the index to a subset of the whole table.
by giovannibonetti 3y ago
Partial indexes solve exactly this problem. You add a WHERE condition that restricts the index to a subset of the whole table.
- frenchyatwork 3y agoPartial indexes are still slower, the database needs to scan the index, and then look for the data, and data is less likely to appear in the same pages.