Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!atl-c02.usenetserver.com!news.usenetserver.com!border1.nntp.ash.giganews.com!nntp.giganews.com!news.glorb.com!postnews1.google.com!not-for-mail
From: srivenu@hotmail.com (srivenu)
Newsgroups: comp.databases.oracle.server
Subject: Re: Optimzer Oddities
Date: 30 Apr 2004 03:39:11 -0700
Organization: http://groups.google.com
Lines: 6
Message-ID: <1a68177.0404300239.795ce28e@posting.google.com>
References: <cfee5bcf.0404290037.674304ae@posting.google.com> <c6rls6$i89$1@hercules.btinternet.com>
NNTP-Posting-Host: 193.32.3.82
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1083321551 6475 127.0.0.1 (30 Apr 2004 10:39:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 30 Apr 2004 10:39:11 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260484

Jonathan,
Would the CBO rewrite this query ? I think the use of aggregate
function constrains the CBO from converting it into a join. Is there
any other way for rewriting the query ?
regards
Srivenu