Subject Re: [firebird-support] Join performance
Author Daniel Rail

At December 11, 2003, 09:51, Sandy wrote:

> Hi,

> I've noticed several times recently that a simple step that seems to speed
> up my queries (sometimes quite substantially) is to replace a join like...

> ... FROM sales INNER JOIN customer ON =

> with this

> ... FROM sale, customer WHERE =

> I was under the impression that both of these methods were pretty much the
> same thing, but apparently not. What is the difference?

What are the generated plans for both syntaxes? And, what are the
indices for both tables?

And, both syntaxes do perform the same thing, but are from 2 different
SQL standards(the first one above is from SQL-92 and above, and the
second one is SQL-89).

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (