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

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimzer Oddities

Re: Optimzer Oddities

From: srivenu <srivenu_at_hotmail.com>
Date: 30 Apr 2004 03:39:11 -0700
Message-ID: <1a68177.0404300239.795ce28e@posting.google.com>


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 Received on Fri Apr 30 2004 - 05:39:11 CDT

Original text of this message

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