You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Xinyi Yan (Jira)" <ji...@apache.org> on 2020/02/20 00:46:00 UTC

[jira] [Created] (PHOENIX-5740) WhereOptmizer doesn't generate optimized query plan

Xinyi Yan created PHOENIX-5740:
----------------------------------

             Summary: WhereOptmizer doesn't generate optimized query plan
                 Key: PHOENIX-5740
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5740
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Xinyi Yan
         Attachments: Screen Shot 2020-02-19 at 4.41.12 PM.png

!Screen Shot 2020-02-19 at 4.41.12 PM.png!

AS we can see, the pattern of WHERE (( all pk conditions) OR ( all pk conditions)) generates the wrong scan.

Instead of a full scan, it should be a point lookup since we have full primary key listed. 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)