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

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple query that consumes all temporary space.

Re: Simple query that consumes all temporary space.

From: ydalepe <ydalepe_at_yahoo.com>
Date: 31 Jan 2005 05:38:42 -0800
Message-ID: <8cc8b677.0501310538.571b0f8b@posting.google.com> 





Joachim:



The query you suggested returned the first rows after 68 hours.
So finally we found that the best alternative we have is to use a
merge join with some filter to take a small set of records from one
table, and the whole other table.



Thanks to you and to everybody that took their time to help us!!



Regards,


ydalepe
Received on Mon Jan 31 2005 - 07:38:42 CST












Original text of this message













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