Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning query
"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