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

Home -> Community -> Usenet -> c.d.o.server -> ANSI syntax slower than old style?

ANSI syntax slower than old style?

From: <duncanstreet2004_at_yahoo.com>
Date: 23 Aug 2006 13:17:57 -0700
Message-ID: <1156364277.549702.117520@m79g2000cwm.googlegroups.com>


Hello,

Are there times when the new, ANSI syntax for joins is slower than the old style or can I assume that ANSI joins are just as fast if done properly?

ANSI Joins
SELECT * from DEPT D
INNER JOIN EMPLOYEES E
ON (D.DEPT_ID = E.DEPT_ID)
WHERE D.DEPT_NAME = 'Human Resources'

Old Style Joins
SELECT * FROM DEPT D, EMPLOYEES E
WHERE D.DEPT_ID = E.DEPT_ID
AND D.DEPT_NAME = 'Human Resources'

Thanks.

Robin Received on Wed Aug 23 2006 - 15:17:57 CDT

Original text of this message

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