Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
It turns out that PHOENIX-2965 has some bugs with indexes:
- COUNT(DISTINCT <indexed column>) does not use the DistinctPrefixFilter
- Once an index is created COUNT(DISTINCT <pk-prefix>) is no longer using the DistinctPrefixFilter
This jira fixes both issues.
Was:
Currently the optimization in PHOENIX-258 is not used for DISTINCT index scans. We should add that as well.