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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-6458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17370410#comment-17370410 ] 

ASF GitHub Bot commented on PHOENIX-6458:
-----------------------------------------

kadirozde opened a new pull request #1256:
URL: https://github.com/apache/phoenix/pull/1256


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@phoenix.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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
>            Priority: Major
>         Attachments: PHOENIX-6458.master.001.patch
>
>
> 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)