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: Thu, 27 Jan 2005 19:47:34 +0100
Message-ID: <pan.2005.01.27.07.22.39.279552@heute-morgen.de> 





On Thu, 27 Jan 2005 01:47:16 -0200, ydalepe wrote:



> the

> query uses the pk index for T1, and it works, taking up some 20 minutes.




Isnt there an index on TXT? Nested Loop on TXT might be reasonable. If you
do WHERE T2.LINE - T1.LINE > 0 this should avoid PK index usage.



Sincerely,


Joachim


-- 
Warnung: \" kann Augenkrebs verursachen. 


Received on Thu Jan 27 2005 - 12:47:34 CST












Original text of this message













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