You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org> on 2015/04/02 16:15:53 UTC

[jira] [Created] (PHOENIX-1801) Support index merge optimizations

Rajeshbabu Chintaguntla created PHOENIX-1801:
------------------------------------------------

             Summary: Support index merge optimizations
                 Key: PHOENIX-1801
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1801
             Project: Phoenix
          Issue Type: New Feature
            Reporter: Rajeshbabu Chintaguntla
            Assignee: Rajeshbabu Chintaguntla
            Priority: Minor


When we have multiple indexes some times there is chance that we may select an index with that we may need to scan through huge number of records to find matching records. But in some cases merging two or more indexes results may give better result.
Support similiar index merge optimizations as in mysql 
https://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html

This can be supported with local indexes without much overhead. We have supported the same feature in hindex(https://github.com/Huawei-Hadoop/hindex/) which is giving better results as well.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)