On Thu, Dec 16, 2004 at 12:01:39 +0100,
Andreas Kretschmer <akretschmer(at)despammed(dot)com> wrote:
> >
> > considering that almost 70% of the rows will be with 'VALUE1', 20%
> > will be with 'VALUE2' and 10% will be with 'VALUE3' on the average.
> >
> > should I create an index to speedup the counts or not ?
>
> Yes.
Indexes will probably not help in this case. Even when looking at 10% of
the rows, a sequential scan is still going to be faster than an index
scan in most cases.