You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2024/04/11 17:53:00 UTC

[jira] [Assigned] (ASTERIXDB-3377) CBO choosing wrong index

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vijay Sarathy reassigned ASTERIXDB-3377:
----------------------------------------

    Assignee: Vijay Sarathy

> 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
>
> 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)