Comment Comment by frenchyatwork 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. parent frenchyatwork 3 years ago