RE: full-scan vs index for "small" tables
- From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Jun 2006 08:56:26 -0000
>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
