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)

Reply via email to