Re: Wrong number of rows in tkprof?

>The number you are seeing is the cardinality as computed by the

If you say 'computed', do you mean, the optimizer sort of predicts a result, regardless of the actual value?

>optimizer. How did you analyse those two tables, if at all?

I didn't analyze the tables at all. That would have been the next step I wanted to do.

>Hth,
>
>Sybrand Bakker, Senior Oracle DBA

Rene

-- 
Recherchen im Schweizerischen Handelsamtsblatt:
http://www.adp-gmbh.ch/SwissCompanies/Search.php3