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 -> How to limit TEMP use on large queries

How to limit TEMP use on large queries

From: Michael <moores_at_my-deja.com>
Date: Fri, 30 Jul 1999 15:07:20 GMT
Message-ID: <7nsf31$hsm$1@nnrp1.deja.com> 





I have queries which join several tables with millions of rows.
I'm not doing any grouping or sorting and I still run out
of TEMP.




How do I make the use of TEMP limited for large non-sorted queries?



--Michael




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Fri Jul 30 1999 - 10:07:20 CDT












Original text of this message













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