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