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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: why the cardinality of explain plan defers with the caridnality in row source operation

Re: why the cardinality of explain plan defers with the caridnality in row source operation

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Tue, 27 Nov 2007 17:47:16 +0100
Message-Id: <10627.1196182036@roughsea.com> 



Ajeet,


     Wolfgang Breitling has several excellent papers on his site (http://www.centrexcc.com), one of which seems to apply very precisely to your question.


HTH


SF










On Die Nov 27 15:15 , "ajeet ojha" sent:








Hello,


 


In my database environment for many of the queires the explain plan cardinality defers (huge difference) with the cardinality shown by row source operations of tkprof.


I have been trying to find all possible reasons - 


 



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 27 2007 - 10:47:16 CST












Original text of this message













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