You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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))
The text was updated successfully, but these errors were encountered:
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))
The text was updated successfully, but these errors were encountered: