Loading...

XML

Word

Printable

When a query has predicates on non-index keys, early order is not performed causing performance regressions.

Repro:

CREATE INDEX ix10 ON default(c1,c2,c3,c4 DESC);

SELECT d.*

FROM default AS d

WHERE c1 = "doc"

    AND c2 = "hello"

    AND ANY v IN a1 SATISFIES v.ac1 END

ORDER BY c4 DESC

LIMIT 20

OFFSET 0;

In 7.1 we can do early order but in 7.2.3 and later we no longer do that, due to the presence of the ANY clause.

is caused by

MB-57666 CBO: optimizer incorrectly pick index with early order unconditionally

MB-57680 [BP to 7.1.5/7.2.1 MB-57666] - CBO: optimizer incorrectly pick index with early order unconditionally

Early order not done when there are extra predicates