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: Does Oracle create temporary indexes for sub queries?

Re: Does Oracle create temporary indexes for sub queries?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 05 Dec 2005 23:17:11 +0100
Message-ID: <j1f9p1h0m8ljnndsa5qb72gbjsnsc5jfsg@4ax.com> 





On 5 Dec 2005 13:12:46 -0800, "dean" <deanbrown3d_at_yahoo.com> wrote:



>And if yes, is there a way to turn them on, using order by or

>something?

>

>THX


>

>Dean




And your version would be? 


Up to including 9i it didn't 


--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Dec 05 2005 - 16:17:11 CST












Original text of this message













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