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

Posted to dev@phoenix.apache.org by "Kadir Ozdemir (Jira)" <ji...@apache.org> on 2021/04/28 17:54:00 UTC

[jira] [Created] (PHOENIX-6458) Using global indexes for queries with uncovered columns

Kadir Ozdemir created PHOENIX-6458:
--------------------------------------

             Summary: Using global indexes for queries with uncovered columns
                 Key: PHOENIX-6458
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6458
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 5.1.0
            Reporter: Kadir Ozdemir


Phoenix client does not use a global index for the queries with the columns that are not covered by the global index. However, there are many cases where using the global index to map secondary keys to primary keys and then retrieving the corresponding rows from the data table results in faster queries. It is expected that such performance improvement will happen when the index row key prefix length is greater than the data row key prefix length for a given query. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)