| 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 |
| Post date | 2019-05-29T14:14:45Z |
29.05.2019 13:37, danyschaer@... [firebird-support] wrote:
--
WBR, SD.
> The very important diference is the plan. 2.5.8 is not using MOVI_FECH index, so it mustRemove "DISTINCT" from subqueries. It is pointless there in any case.
> read more than one millon records to analize ("MOVI"."FECH" between '20190301' and
> '20190412').
--
WBR, SD.