Re: SQL tuning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 3 May 2004 09:17:09 +0000 (UTC)
Message-ID: <c752ml$qnt$1@hercules.btinternet.com>

Note in-line

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

June  2004      UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar

"dias" <ydias_at_hotmail.com> wrote in message
news:55a68b47.0405022350.e5eb14a_at_posting.google.com...


> Hi Jonathan,

>

> The /*+ unnest */ hint fixed the problem.

> I thought that when the parameter "_unnest_subquery" is set to true (by

default)


> it was sufficient, but ...

>


    So did I.



> Thanks again

>

> Dias

Received on Mon May 03 2004 - 04:17:09 CDT