I see your point. The answer to my question "why would you do that instead
of ... " is, of course, "because the other way might be faster."
Read Jonathan Lewis' earlier post, he had (as always) some good insight.
> -----Original Message-----
> From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca]
>
> Which way is faster? The subselect(nested select) or the join?
>
> Quoting Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>:
>
> > Why would you do that instead of
> > SELECT emp.deptno, empno, ename
> > FROM emp a, dept b
> > WHERE dept.deptno = emp.deptno
> > order by dept.deptname ;
> >
> > > -----Original Message-----
> > > From: Nicoll, Iain [mailto:IAIN.D.NICOLL_at_saic.com]
> > >
> > > Don't really know but couldn't it be useful if you had
> > >
> > > ORDER BY ( SELECT deptname FROM dept
> > > WHERE dept.deptno = emp.deptno)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 04 2003 - 16:14:20 CST
