Vijay Sarathy created ASTERIXDB-3377:
----------------------------------------
Summary: CBO choosing wrong index
Key: ASTERIXDB-3377
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3377
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Vijay Sarathy
For the following query, CBO chooses an index intersection plan of the indexes
on S.u64 and S.u256. S.u64 is a column with 1..64 unique values, so the
predicate S.u64 < 100 is not a good predicate to use the S.u64 index. The plan
should only use the index on S.u256
select * from S where int64_default_null(S.u64) < 100 and
int64_default_null(S.u256) = 10;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
