[PHOENIX-186] Take advantage of region boundaries for min/max queries

• Type: Task
• Status: Resolved
• Resolution: Not A Problem
• Labels: enhancement
• old issue number: 55
• Assignee: Unassigned
• Reporter: ryang-sfdc
• Created: 10/Mar/14 23:46
• Updated: 10/Feb/15 20:44
• Resolved: 10/Feb/15 20:44

Description

Rowkey is led by date non null.

explain select max(date) from foobar where date < to_date('2013-02-17 00:00:00')

[["PLAN"],
["CLIENT PARALLEL 7-WAY RANGE SCAN OVER FOOBAR TO (2013-02-17 00:00:00) EXCLUSIVE"],
[" SERVER FILTER BY FirstKeyOnlyFilter"],
[" SERVER AGGREGATE INTO SINGLE ROW"]]

Does this plan imply we scan from the beginning of the table up to the specified endpoint?