[ https://issues.apache.org/jira/browse/ASTERIXDB-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon updated ASTERIXDB-3377: --------------------------------- Labels: triaged (was: ) > 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 > Assignee: Vijay Sarathy > Priority: Major > Labels: triaged > > 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)