2 ms·
Partial 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.
by frenchyatwork 3y ago
Partial 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.