Re: Why won't it index scan?

On Mon, May 22, 2006 at 05:55:16PM -0700, Joshua D. Drake wrote:
>
> >The reason the default is currently 10 is just conservatism: it was
> >already an order of magnitude better than what it replaced (a *single*
> >representative value) and I didn't feel I had the evidence to justify
> >higher values. It's become clear that the default ought to be higher,
> >but I've still got no good fix on a more reasonable default. 100 might
> >be too much, or then again maybe not.
> >
>
> My hands on experience is that 10 is plenty except for the minority of
> tables within a database. Those table can be accurately represented
> using alter table without having to adjust the global.

Ditto.

> That being said, 10 is fairly small and I often find myself setting the
> value to at least 250 just to keep it out of my way.

And ditto (though I normally go for 100).

Have you ever run into problems from setting this too high?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461