You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/04/16 17:25:00 UTC
[jira] [Commented] (ASTERIXDB-3377) CBO choosing wrong index
[ 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 <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: <mu...@couchbase.com>
Reviewed-by: Vijay Sarathy <vi...@couchbase.com>
> 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)