| Subject | RE: [ib-support] 3 table join with SQL statements runs slow |
|---|---|
| Author | Leyne, Sean |
| Post date | 2002-06-11T18:56:26Z |
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.
Sean
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.
Sean