Maryann Xue created PHOENIX-3129:
------------------------------------
Summary: Use non-covering global index automatically without hint
if the filter is selective enough
Key: PHOENIX-3129
URL: https://issues.apache.org/jira/browse/PHOENIX-3129
Project: Phoenix
Issue Type: Improvement
Affects Versions: 4.8.1
Reporter: Maryann Xue
Assignee: Maryann Xue
Right now, if a global index is non-covering and if the where clause will favor
the usage of that global index, we need the user to specify an INDEX hint to
make use of that global index by rewriting the query into an IN subquery.
For some filters, like for example, "where idx_pk = ?", we can turn on this
optimization automatically even without the presence of the hint.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
