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)