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

On 6/30/06, Laimutis Nedzinskas <Laimutis.Nedzinskas@xxxxxxxxxxxxx> wrote: 

>I want an index to be used if it exists, regardless of statistics,
period.

Yes, it is ...annoying when someone [Oracle] thinks he is smarter than
you and it commands you what to do.
The strategy "if index was created then it was created for a reason -
use it" makes a sense.



But you are assuming that the application will implement the correct number
of indices that are required :)

You should see some of the applications I have to deal with, most of times
it is a matter of adding missing indices or removing unwanted ones...and
amazing experience .. and don't get me started on missing constraints  :D


--
Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland

Other related posts: