Hi
tested on WI-V3.0.5.33187 Firebird 3.0 and WI-V3.0.5.33232 Firebird 3.0
i see that my query have legacy plan like this:
PLAN (RL ORDER PK_ROZLICZENIE)
but explained plan show this
Select Expression
-> Filter
-> Table "ROZLICZENIE" as "RL" Access By ID
-> Index "PK_ROZLICZENIE" Range Scan (lower bound: 2/5, upper
bound: 3/5)
which plan finaly engine have?
1. RL ORDER PK_ROZLICZENIE
2. RL INDEX (PK_ROZLICZENIE)
3. RL ORDER PK_ROZLICZENIE INDEX (PK_ROZLICZENIE)
-------------------------------------------------------------------------
query is:
SELECT
RL.DYR_ID
, RL.INSP_ID
, RL.OKRES_NUMER
, RL.ROZLICZ_NR
, RL.ROZLICZ_NR_POZ
FROM
ROZLICZENIE RL
WHERE
RL.OKRES_NUMER <= '2020.01'
AND (RL.DYR_ID = 3 AND RL.INSP_ID = 7)
ORDER BY
RL.DYR_ID
, RL.INSP_ID
, RL.OKRES_NUMER
, RL.ROZLICZ_NR
, RL.ROZLICZ_NR_POZ
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
