[PHOENIX-505] Optimize MIN and MAX when column leads row key

• Type: Task
• Status: Open
• Resolution: Unresolved
• old issue number: 374
• Assignee: Haoran Zhang
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:47
• Updated: 28/Apr/16 01:55

Description

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.