[
https://issues.apache.org/jira/browse/PHOENIX-4972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16649737#comment-16649737
]
Lars Hofhansl commented on PHOENIX-4972:
----------------------------------------
The first query above sorts (topN scans) the entire table, the latter scans
along the index and joins back the few matching rows. It should be possible to
rewrite the query accordingly, it's almost always beneficial to avoid a full
sort/scan.
> ORDER BY should use a GLOBAL index even if the query is not fully covered
> -------------------------------------------------------------------------
>
> Key: PHOENIX-4972
> URL: https://issues.apache.org/jira/browse/PHOENIX-4972
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Lars Hofhansl
> Priority: Minor
>
> Like PHOENIX-4964 but for global indexes
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
