Re: Simple query that consumes all temporary space.

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.