Re: How to limit TEMP use on large queries

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 30 Jul 1999 16:21:37 +0100
Message-ID: <933348555.5618.1.nnrp-03.9e984b29@news.demon.co.uk>

The TEMP usage will be down to
sort merge joins or hash joins

Add a few hints to the query to
restrict it to using indexed
nested loop joins.

The query may run more slowly,
but it won't use TEMP.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Michael wrote in message <7nsf31$hsm$1_at_nnrp1.deja.com>...
>I have queries which join several tables with millions of rows.
>I'm not doing any grouping or sorting and I still run out
>of TEMP.
>
>
>How do I make the use of TEMP limited for large non-sorted queries?
>
>--Michael
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 30 1999 - 10:21:37 CDT