Re: ANSI syntax slower than old style?

duncanstreet2004_at_yahoo.com wrote:
> 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

Certainly when writing the SQL statement.

Does your instance have a version number?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org