Posted by Serge Rielau on 02/01/07 16:14

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

[Back to original message]