Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ANSI syntax slower than old style?
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
![]() |
![]() |