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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 8i join and 10g ANSI join syntax

Re: 8i join and 10g ANSI join syntax

From: <sybrandb_at_yahoo.com>
Date: 2 Feb 2006 03:37:01 -0800
Message-ID: <1138880221.000402.222280@g49g2000cwa.googlegroups.com> 





1 yes


2 after the join, if hiredate is unindexed.
You can verify this by using dbms_xplan (in 9i and higher)



Hth

-- 
Sybrand Bakker
Senior Oracle DBA


Received on Thu Feb 02 2006 - 05:37:01 CST












Original text of this message













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