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

Other related posts: