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

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "ajeet ojha" <oraclev28@xxxxxxxxx>
  • Date: Tue, 27 Nov 2007 17:47:16 +0100

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 -
 

-- //www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007