[IGNITE-13568] Calcite integration. Decrease bounds of index scan

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required
• Epic Link: AI3 Performance
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 09/Oct/20 11:37
• Updated: 13/Jun/23 13:35

Description

As of now, we analyze just the first column from predicate to detemine lower and upper bounds for complex indexes in case first predicate is not equal. It decreasing search space, however for particular cases, it could be not so effective, for example, the selectivity of the first column is very low. We need to take into account all columns from predicate and suitable index. Need to keep in mind that each column at the index could be sorted in a different manner.
Start point right now is org.apache.ignite.internal.processors.query.calcite.util.RexUtils#buildIndexConditions, could be refactored before the ticked will be started.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine