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

Just to be sure you don't miss J. Lewis' "Cost based optimizer" book and his web site.

On 12/4/07, John Kanagaraj <john.kanagaraj_at_gmail.com> wrote:
> > > 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
>
>
>

-- 
Regards,
Ranko Mosic
Consultant Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l