Re: why the cardinality of explain plan defers with the caridnality in row source operation
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
- To: smeghead.rimmer@xxxxxxxxx
- Date: Tue, 4 Dec 2007 16:16:36 -0800
> > 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 **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
