Posted by dunleav1 on 02/01/07 18:28

On Feb 1, 11:14 am, Serge Rielau <srie...@ca.ibm.com> wrote:
> dunleav1 wrote:
> > I have an application that uses the old join syntax instead of the
> > SQL92 standards join syntax.
> > I need to justify changing the code to the new standard.
> > Is there any performance issue related to using the old syntax that
> > are documented?
> > Are there any other issues that I use to justify a code upgrade?
>
> Careful.. when you refer to "old join syntax" in this group readers will
> assume you mean TSQL proprietary *= syntax for outer joins and not
> "implicit join syntax". For implicit inner joins please see my answer in
> c.d.ibm-db2.
> If you in fact do outer joins using *= or Oracle style (+) syntax things
> are different. Portability would be one reason to abandon proprietary
> syntax for ANSI syntax.
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
Serge,
I believe we are in agreement but let me give you an example about
what I referring to:
sql89: select tab1.col1 from tab1,tab2 where tab1.col1=tab2.col and
tab1.col1 >1;
sql92: select tab1.col1 from tab1 inner join tab2 on
tab1.col1=tab2.col2 where tab1.col1 >1;
Is there a performance impact using one syntax over the other?

I agree it is a good idea to not use proprietary sql extensions such
as (tab1(+) for Oracle or Mssql *=).

[Back to original message]