Hi, i do not know if this is related to CORE-4809 or should i report this as new ticket in tracker? for query SELECT * FROM RDB$RELATION_FIELDS RF left join RDB$RELATIONS R on R.RDB$FIELD_ID+0 = RF.RDB$FIELD_POSITION WHERE RF.RDB$RELATION_NAME='RDB$RELATIONS' we got PLAN JOIN (RF INDEX (RDB$INDEX_4), R NATURAL) and stats are RDB$RELATION_FIELDS - 17 indexed reads RDB$RELATIONS - 4505 sequential reads but should this be as a HASH JOIN? to limit 4505 reads to only few? regards, Karol Bieniaszewski
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
