[
https://issues.apache.org/jira/browse/ASTERIXDB-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837799#comment-17837799
]
ASF subversion and git services commented on ASTERIXDB-3377:
------------------------------------------------------------
Commit 29f1d423b7a8ebff0abc7ff40534463a66b1a33b in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=29f1d423b7 ]
[ASTERIXDB-3377][COMP]: CBO choosing wrong index
Change-Id: I81a6dcca634d3d30f0b101baabe4093fb01123d0
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18236
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: <[email protected]>
Reviewed-by: Vijay Sarathy <[email protected]>
> 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)
