[
https://issues.apache.org/jira/browse/PHOENIX-28?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-28.
---------------------------------
Resolution: Fixed
> 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)
