ruan_h wrote:

>
> Had a query running much slower in 2.1.2 than in 2.0.3

I suspect you compare Linux vs Windows builds, or release vs debug ones.
Could it be true?

> Both 2.1.2. and 2.0.3 choose this plan:
>
> PLAN (EXCLUDEDFILE INDEX (EXCLUDEDFILE_IDX1, EXCLUDEDFILE_IDX1))
> PLAN (ALLFILE NATURAL)
>
> 2.0.3 does 3 natural reads on AllFile, and 2 index reads on ExcludedFile, because it applies allfile.filename = '1.TXT' first.
>
> 2.1.2 does 3 natural reads on AllFile, but also 6 index reads on ExcludedFile, because it applies allfile.filename = '1.TXT' last.

On my machine, v2.1.2 produces 2 index reads on ExcludedFile. The same
is for v2.0.5.


Dmitry