[ https://issues.apache.org/jira/browse/PHOENIX-505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-505: --------------------------------- Assignee: Dongming Liang > 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 > 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)