[jira] [Created] (PHOENIX-7766) Generate point lookups while using IS NULL on trailing PK columns

["Sanjeet Malhotra (Jira)" <ji...@apache.org>]

Sanjeet Malhotra created PHOENIX-7766:
-----------------------------------------

             Summary: Generate point lookups while using IS NULL on trailing PK columns
                 Key: PHOENIX-7766
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7766
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Sanjeet Malhotra
            Assignee: Sanjeet Malhotra


Currently, Phoenix explicitly prevents generating point lookups if a query has WHERE clause such that there is IS NULL condition on trailing PK columns. 
The proposal in this Jira is to generate point lookups for above case. This will especially be useful for cases when a new nullable PK column is added to a table and because of addition of new PK columns earlier single point lookups and multi point lookups regress to range and skip scan. The proposal will help prevent such regression.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)