FreeLists / oracle-l / Re: why the cardinality of explain plan defers with the caridnality in row source operation

["John Kanagaraj" <john.kanagaraj@xxxxxxxxx>]

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