RE: full-scan vs index for "small" tables

>From: Wolfgang Breitling
>If you don't want this kind of surprise - or others related to statistics - take control of the statistics gathering.

*YES* In the other words: drop all intelligence, drop all AUTO stuff (including ... CBO ... if possible)

>You don't just take init.ora defaults, why would you accept the statistics gathering defaults?

I humbly acknowledge - I am sorry. I was still naïve enough to believe vendors recommendations are to be followed, at least sometimes.

Thank you very much,
Laimis N.

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l