[ 
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)

Reply via email to