Subject | INNER JOIN after LEFT OUTER JOIN |
---|---|
Author | ruan_h |
Post date | 2010-07-01T22:28:35Z |
Hello All
I remember there was a performance issue with INNER JOIN after LEFT OUTER JOIN in Firebird 1.5, but I can't exactly remember the details. e.g.
SELECT
TableA.Something
FROM TableA
LEFT OUTER JOIN TableB ON TableB.RefA = TableA.RefA
INNER JOIN TableC ON TableC.RefC = TableB.RefC
Now we have been using 2.1.3 for a while. Does anyone know if the same issue still applies or this has been improved?
Thanks
Huan
I remember there was a performance issue with INNER JOIN after LEFT OUTER JOIN in Firebird 1.5, but I can't exactly remember the details. e.g.
SELECT
TableA.Something
FROM TableA
LEFT OUTER JOIN TableB ON TableB.RefA = TableA.RefA
INNER JOIN TableC ON TableC.RefC = TableB.RefC
Now we have been using 2.1.3 for a while. Does anyone know if the same issue still applies or this has been improved?
Thanks
Huan