[
https://issues.apache.org/jira/browse/ASTERIXDB-3167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
murali krishna updated ASTERIXDB-3167:
--------------------------------------
Summary: Analytics is choosing suboptimal index paths (was: Analytics CBO
is choosing suboptimal index paths)
> Analytics 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
>
> With the CBO, analytics optimizer 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)
