[jira] [Updated] (ASTERIXDB-3167) Optimizer is choosing suboptimal index paths

["Ali Alsuliman (Jira)" <ji...@apache.org>]

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

Ali Alsuliman updated ASTERIXDB-3167:
-------------------------------------
    Summary: Optimizer is choosing suboptimal index paths  (was: Analytics is choosing suboptimal index paths)

> Optimizer is choosing suboptimal index paths
> --------------------------------------------
>
>                 Key: ASTERIXDB-3167
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3167
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: murali krishna
>            Priority: Major
>
> analytics optimizer (RBO and hence CBO) is choosing two indexes and intersection when it can simply choose one index (wider one).
> create a collection c and load some data; loaded 1664 documents.
> create index ic1a on c(a:int);
> create index ic1b on c(a:int, b:int);
> analyze analytics collection c;
> select count(distinct uuid) from c
> where a = 1 and b between 100 and 200;
> The plan shows the intersection of results from the two scans on ic1a and ic1b.
> the plan can simply choose ic1b and be efficient



--
This message was sent by Atlassian Jira
(v8.20.10#820010)