Yury Gerzhedovich created IGNITE-13568:
------------------------------------------
Summary: Calcite integration. Decrease bounds of index scan
Key: IGNITE-13568
URL: https://issues.apache.org/jira/browse/IGNITE-13568
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Yury Gerzhedovich
As of now, we analyze just the first column from predicate to detemine lower
and upper bounds for complex indexes. 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)