murali krishna created ASTERIXDB-3167:
-----------------------------------------
Summary: Analytics CBO 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
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)
