I?m encountering some strange problems with the CBO in Oracle 184.108.40.206 ? it?s telling me that I have more rows in the indexes than there are rows in the tables.
I?ve tried all combinations of dbms_stats and analyse and cannot understand how the CBO comes up with such numbers. I?ve even done a ?delete statistics? and
Re-analysed the table and indexes but it doesn?t help.
The command I used is variations of the following:
exec DBMS_STATS.GATHER_TABLE_STATS(ownname=>'MBS',tabname=>'READINGTOU', -
estimate_percent=>dbms_stats.auto_sample_size,method_opt=>'FOR COLUMNS PROCESSSTATUS',degree=>2);