Submitted by: @livius2

Relate to CORE5782
Is duplicated by CORE5782

Votes: 5

example

SELECT
*
FROM
RDB$RELATION_FIELDS RF
left join RDB$RELATIONS R on R.RDB$SYSTEM_FLAG = RF.RDB$FIELD_POSITION
WHERE
RF.RDB$RELATION_NAME BETWEEN 'RDB$RELATIONS' AND 'RDB$RELATIONS2'

PLAN JOIN (RF INDEX (RDB$INDEX_4), R NATURAL)

will be good to see here HASH like is done for inner joins
PLAN HASH (R NATURAL, RF INDEX (RDB$INDEX_4))