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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.8.1
• Labels: secondary_index
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 29/Jul/16 18:54
• Updated: 29/Jul/16 18:54

Description

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.