Subject RE: [ib-support] 3 table join with SQL statements runs slow
Author Leyne, Sean
Please post the PLAN used by the query, for both IB 4.1 and Firebird.

Also, there was a number of 'optimizations' which were attempted between
4.1 and 6.0, so you might find that restating the query using SQL-92
syntax (i.e. SELECT ... From A Join B on B.ID = A.FK_ID) might yield a
better performance for Firebird.