Predicates are considered independed. Selectivity is multiplied for
independent predicates so that is you have any correlation, then the
estimation would be lower than the real number. Plus, if you don't have a
histogram your skewed data in a column could be a source of even bigger
estimation error.
"srivenu" <srivenu_at_hotmail.com> wrote in message
news:1a68177.0304140430.5476c836_at_posting.google.com...
> We are running Oracle 8.1.7.0 on Sun Solaris 8.
> When i run the following SQL statement, i get wrong value for
> cardinality in the Execution plan.
Received on Mon Apr 14 2003 - 12:02:00 CDT
