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

> > 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 -

Also look at Wolfgang "10053" Breitling's paper "Tuning by Cardinality Feedback" on http://www.centrexcc.com/ This will help you understand this issue using examples.

-- 
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l