[
https://issues.apache.org/jira/browse/PHOENIX-505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14505909#comment-14505909
]
Dongming Liang commented on PHOENIX-505:
----------------------------------------
Will work on this issue.
> Optimize MIN(col) when col leads row key
> ----------------------------------------
>
> Key: PHOENIX-505
> URL: https://issues.apache.org/jira/browse/PHOENIX-505
> Project: Phoenix
> Issue Type: Task
> Reporter: James Taylor
>
> We should be able to change an aggregate query to a scan with LIMIT 1 if the
> only aggregation is MIN(value) when the index is on value ASC and MAX(value)
> when the index is on value DESC. Might be able to optimize the reverse too,
> by finding the largest possible value, but need to test this.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
