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: Joachim Zobel <jz-2004_at_heute-morgen.de>
Date: Mon, 31 Jan 2005 20:09:18 +0100
Message-ID: <pan.2005.01.31.19.09.18.295941@heute-morgen.de>


On Mon, 31 Jan 2005 05:38:42 -0800, ydalepe wrote:

> 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.

At least it solved the temp space problem :-) There must be a better way. Is TXT indexed?

Sincerely.
Joachim

-- 
Warnung: \" kann Augenkrebs verursachen. 
Received on Mon Jan 31 2005 - 13:09:18 CST

Original text of this message

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