Re: New ANSI SQL not available in Oracle?

A copy of this was sent to yong321_at_yahoo.com (if that email address didn't require changing) On Fri, 25 Jun 1999 15:54:10 GMT, you wrote:

>I read this at a MS SQL server group. If the new syntax is faster, why
>is Oracle not adopting it?
>

its part of a higher level of ANSI SQL92 then any vendor fully supports. there are 4 levels of compliance with ANSI SQL92

• entry level (the only level to which any vendor complies)
• intermediate
• transtional
• full

Every vendor supports various bits and pieces of higher levels of sql compliance. MS has some they support, we have other bits and pieces we do.

As for the inner join syntax being 'faster' -- I would disagree. To parse and compile:

select * from emp, dept where emp.deptno=dept.deptno

should compile faster then the corresponding inner join syntax as the compiler doesn't have to figure out the join conditions for you -- you've done that. It would compile slower and execute at the same speed.

>Yong
>yong321_at_yahoo.com
>________________________________________________________________________
>Subject: Re: The difference between left join and regular select
>
>These are just two different ways to achieve the same result.
>
>The second method is considered "old". Perhaps someday it will be
>abandoned. I believe Sybase and Oracle still only use this method.
>
>The first one is the ANSI-SQL type, introduced in MS-SQL Server 6.5. It
>compiles faster and you should prefer it.
>
>P.A.
>
>fran wrote in message <7kuouj$a2v_at_nntpb.cb.lucent.com>...
>>Should anybody tell me the difference between the left join and the
>regular
>>select clause, to me it seems give the same result:
>>1.
>> select a.col1,a.col2,b.col3,b.col4
>> from table1 a
>> inner join table2 b
>> on a.item1=b.item2
>>2.
>> select a.col1,a.col2,b.col3,b.col4
>> from table1 a,table2 b
>> where a.item1=b.item2
>>
>>The above two will give the same result.
>>Will anybody give me an explanation?
>>
>>Thanks in Advance
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jun 25 1999 - 11:57:29 CDT