Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!p10g2000cwp.googlegroups.com!not-for-mail
From: ronnie_yours@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Query Runs faster in 10G
Date: 3 Mar 2006 13:11:19 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <1141420279.500669.284230@p10g2000cwp.googlegroups.com>
References: <1141417760.979675.54930@z34g2000cwc.googlegroups.com>
   <dua9q7$q31$1@news5.zwoll1.ov.home.nl>
NNTP-Posting-Host: 64.201.8.130
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1141420285 13090 127.0.0.1 (3 Mar 2006 21:11:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 3 Mar 2006 21:11:25 +0000 (UTC)
In-Reply-To: <dua9q7$q31$1@news5.zwoll1.ov.home.nl>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: p10g2000cwp.googlegroups.com; posting-host=64.201.8.130;
   posting-account=tX4fGwwAAAA7jNMfYzgk596bkdoCBp9f
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262738

Thanks Frank,

I have been assigned the task to optimise this query on 8i. I would
really appreciate any suggestions.

-Ron



> Apart from the obvious "yet another reason to upgrade to 10g", your
> execution plans differ. One, because ALL_ROWS is the goal in 10g, and
> CHOOSE in 8i.
> Don't recall if ALL_ROWS appears in an explain plan unless it it set,
> either at instance, or at session level.
>
> --
> Regards,
> Frank van Bortel
> 
> Top-posting is one way to shut me up...