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 00:15:10 -0700
Message-ID: <1a68177.0404292315.4857ad7e@posting.google.com>


Jonathan,
Please correct me if i'am wrong in making the observation that since the sub query contains an aggregate function, the optimizer cannot rewrite the query and covert it into a join. Or are there any other ways that the CBO might rewrite the query ? thanks & regards
Srivenu Received on Fri Apr 30 2004 - 02:15:10 CDT

Original text of this message

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