Subject | Re: [ib-support] Assure me |
---|---|
Author | Pete Clark |
Post date | 2003-01-13T11:48:39Z |
In message <5.1.0.14.0.20030113110849.02494ab0@[158.36.132.22]>, Svein
Erling Tysvaer <svein.erling.tysvaer@...> writes
Like, a spread of 50% ( a boolean field ) is obviously silly. But what
sort of percentage should I drop to, before actually creating an index?
--
Pete Clark
Erling Tysvaer <svein.erling.tysvaer@...> writes
>The number of indexes is not all too important, what matters is theirIs there some sort of way of figuring out what the 'boundary' is?
>selectivity. Just make sure you do not create indexes on fields for which
>many records hold the same values.
Like, a spread of 50% ( a boolean field ) is obviously silly. But what
sort of percentage should I drop to, before actually creating an index?
--
Pete Clark