Subject Re: 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 Dimitry Sibiryakov
29.05.2019 13:37, danyschaer@... [firebird-support] wrote:
> The very important diference is the plan. 2.5.8  is not using MOVI_FECH index, so it must
> read more than one millon records to analize ("MOVI"."FECH" between '20190301' and
> '20190412').

Remove "DISTINCT" from subqueries. It is pointless there in any case.