it's easy to check - use a tool which gives you prepare, fetch times etc.
I certainly haven't noticed any - if it's no good for one syntax it will be
no good for the other.. probably because of missing indexes or generally bad
SQL which prevents the optimiser from recognising the best plan (indexes) to
use.
Alan

-----Original Message-----
From: ronaldorezende [mailto:ronaldinho79@...]
Sent: Thursday, 6 March 2003 11:36 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: sql - diference in join tables


Is there any difference in performance ?

--- In ib-support@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> reading the IBO documents tells me that the id1=id2 syntax is the
older SQL
> format which is also supported by IB/FB
> The explicit JOIN syntax is newer and (allows IBO anyway) to do some
> intelligent things with you SQL e.g. create an update statement
properly
> without you having to edit it to correct something it may have
> misunderstood.
>
> Either syntax will bring back the same result in most cases
(barring other
> differences in your statement).
> But I think you should be encrouaged to use the JOIN syntax where
possible.
> Alan
> (I may be completely wrong here :-)))
>
> -----Original Message-----
> From: ronaldorezende [mailto:ronaldinho79@b...]
> Sent: Thursday, 6 March 2003 11:16 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] sql - diference in join tables
>
>
> Is there any diference in sql joins using where id1 = id2 or using
> the left command ?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/