Ann W. Harrison wrote:

> It's hard to come up with really good rules about indexes. The normal
> example of a field that should not be indexed is sex - where there are
> two values and about equal distribution. On the other hand, if you
> had a table of inhabitants of a nunnery, an index on sex would be good
> if you often wanted to find the males.

So, as a rule of thumb, you would use indexes to make it easier to find
the needles in the haystack, but not for finding the hay? :-)

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64