Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ANSI Joins

Re: ANSI Joins

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 19 Jan 2005 10:19:09 +0000
Message-ID: <7765c8970501190219518a20de@mail.gmail.com>


On Tue, 18 Jan 2005 13:45:03 -0500, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
> My developers are starting to use ANSI joins in vain hope that they will
> make their apps portable
> across databases.

Of course they will be portable - assuming competent devs - in fact they will probably have similar performance characteristics across platforms as well. Consider JAVA it too is perfectly portable and it too performs similarly across platforms ;-)

> I have a positive attitude toward ANSI joins: I hate
> those verbose extensions
> that make SQL statements lengthy and unreadable. What is the opinion of
> other people about ANSI joins?

I like the 'ANSI' syntax, it helps me as an occasional writer of SQL to think about what my join conditions are and what my filters are, more to the point it certainly helps me as a frequent *reader* of SQL understand what some developer is attempting to achieve.

I take Stephanes point that the order of execution chosen by the DBMS may well not match the order of things in the SQL that is issued, but the old style of doing things (everything in the where clause) also may not match the order of execution chosen by the DBMS , but does make it remarkably easy to miss filter or join conditions out entirely. anything that makes good code easier to write is a good thing in my view and the 'ANSI' layout does that at least for me.

my 2c

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 19 2005 - 05:22:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US