[
https://issues.apache.org/jira/browse/ASTERIXDB-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay Sarathy resolved ASTERIXDB-3377.
--------------------------------------
Resolution: Fixed
> 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)
