[jira] [Created] (PHOENIX-3129) Use non-covering global index automatically without hint if the filter is selective enough

["Maryann Xue (JIRA)" <ji...@apache.org>]

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)