James Taylor created PHOENIX-28:
-----------------------------------

             Summary: Optimizer not always correctly choosing point lookup plan
                 Key: PHOENIX-28
                 URL: https://issues.apache.org/jira/browse/PHOENIX-28
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor
             Fix For: 2.2.3


Instead of always choosing a query plan that does a point lookup, the optimizer 
may choose one that instead prevents an ORDER BY, but causes a range scan 
instead. It's better (in the absence of stats) to choose the point lookup plan 
and do the ORDER BY on the results than to do a range scan with a filter on 
each row.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to