[jira] [Created] (IGNITE-17250) Calcite. Make 'min()/max()' use first/last index value.

[Vladimir Steshin (Jira)]

Title: Message Title

Vladimir Steshin created an issue   Ignite / IGNITE-17250 Calcite. Make 'min()/max()' use first/last index value. Issue Type: Improvement Assignee: Vladimir Steshin Created: 28/Jun/22 11:20 Priority: Major Reporter: Vladimir Steshin Currently, Calcite's plan on min()/max() is the table scan and the aggregation n the indexed field: "select min(salary) from Person" Plan: IgniteReduceHashAggregate(group=[{}], MAX(SALARY)=[MAX($0)]) IgniteExchange(distribution=[single]) IgniteMapHashAggregate(group=[{}], MAX(SALARY)=[MAX($0)]) IgniteTableScan(table=[[PUBLIC, PERSON]], requiredColumns=[{3}]) We could pick up first index record. No need to scan. Add Comment   This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)