Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.mailgate.org!skynet.be!newspost001!tjb!not-for-mail
Reply-To: "Matthias Hoys" <anti@spam.com>
From: "Matthias Hoys" <anti@spam.com>
Newsgroups: comp.databases.oracle.server
References: <1141417760.979675.54930@z34g2000cwc.googlegroups.com>   <dua9q7$q31$1@news5.zwoll1.ov.home.nl> <1141420279.500669.284230@p10g2000cwp.googlegroups.com>
Subject: Re: Query Runs faster in 10G
Date: Fri, 3 Mar 2006 23:42:41 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Lines: 17
Message-ID: <4408c662$0$26758$ba620e4c@news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: bfef1747.news.skynet.be
X-Trace: 1141425762 news.skynet.be 26758 81.245.232.84:2359
X-Complaints-To: usenet-abuse@skynet.be
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262751


<ronnie_yours@yahoo.com> wrote in message 
news:1141420279.500669.284230@p10g2000cwp.googlegroups.com...
> Thanks Frank,
>
> I have been assigned the task to optimise this query on 8i. I would
> really appreciate any suggestions.
>
> -Ron
>
>
 Have you tried using the ALL_ROWS hint ? SELECT /*+ ALL_ROWS */ FROM ...


Matthias