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