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)