Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning query

Re: Tuning query

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Dec 2002 15:34:37 -0000
Message-ID: <3deccf11$0$711$ed9e5944@reading.news.pipex.net>


"rajXesh" <member_at_dbforums.com> wrote in message news:2115106.1038858559_at_dbforums.com...
>
> Can you try to use the use_hash hint
>
> select /*+ use_hash(rr3dim3 rr0dim4) */

Thanks thats much nicer than pointing out that the explain plans aren't the same and I can't read.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Tue Dec 03 2002 - 09:34:37 CST

Original text of this message

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