[
https://issues.apache.org/jira/browse/PHOENIX-505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-505:
---------------------------------
Summary: Optimize MIN and MAX when column leads row key (was: Optimize
MIN(col) when col leads row key)
> Optimize MIN and MAX when column leads row key
> ----------------------------------------------
>
> Key: PHOENIX-505
> URL: https://issues.apache.org/jira/browse/PHOENIX-505
> Project: Phoenix
> Issue Type: Task
> Reporter: James Taylor
> Assignee: Dongming Liang
>
> 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)
