firebird-support - ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9

Subject	ODP: [firebird-support] Query that was very fast under the oldest 2.5 versions are very slow under 2.5.8 or 2.5.9
Author	Karol Bieniaszewski
Post date	2019-05-27T20:16:29Z

Do you use FB3 Super Server or Classic?

What value of PagePuffers and PageSize?

I see big reads but also big indexes reads but fetches are lower.

There is also one plan difference

MOVI INDEX (MOVI_PROC) vs MOVI INDEX (MOVI_PROC, MOVI_FECH)

But i am intersted how this looks like at second run with big cache

Regards,

Karol Bieniaszewski