Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: full-scan vs index for "small" tables

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

From: Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>
Date: Fri, 30 Jun 2006 08:56:26 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B02CA2C2@W03856.li01r1d.lais.net>


>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
Received on Fri Jun 30 2006 - 03:56:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US