[IGNITE-13030] Calcite integration. Push projections to scans and avoid reading full row when possible

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.15
• Component/s: sql
• Labels: calcite
• Release Note: SQL Calcite: Added ability to scan inlined keys of indexes without additional requests to data pages.
• Ignite Flags: Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Roman Kondakov
• Created: 18/May/20 19:26
• Updated: 21/Dec/22 08:45
• Resolved: 09/Dec/22 06:37

Description

We can establish index-only scans in some cases. For example, if the column depId is indexed (and totally inlined), we can to execute a query like:

SELECT depId FROM emp

and collects resultset without pagememory lookups.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #10397