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.31.35.530900@heute-morgen.de>

On Tue, 25 Jan 2005 14:13:46 -0800, ydalepe wrote:

> SELECT T1.LINE LINE1, T2.LINE LINE2
> FROM T T1, T T2
> WHERE T2.LINE > T1.LINE
> AND T1.TXT = T2.TXT
> GROUP BY T1.LINE, T2.LINE
> HAVING COUNT(*) >= 3
SELECT T1.LINE LINE1, T2.LINE LINE2
  FROM T T1, T T2
 WHERE T2.LINE > T1.LINE
   AND 3 =< (SELECT COUNT(1)

               FROM T S1, T S2
              WHERE S1.LINE = T1.LINE
                AND S2.LINE = T2.LINE
                AND S1.TXT = S2.TXT)
   -- This is to get every line only once       

   AND T1.POS=1
   AND T2.POS=1; might behave better.

Sincerely,
Joachim

-- 
Warnung: \" kann Augenkrebs verursachen. 

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