Re: [SQL] [despammed] question about index

2004-12-16 Thread Andreas Kretschmer
am 16.12.2004, um 8:10:25 -0600 mailte Bruno Wolff III folgendes: > On Thu, Dec 16, 2004 at 12:01:39 +0100, > Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > > > > > > considering that almost 70% of the rows will be with 'VALUE1', 20% > > > will be with 'VALUE2' and 10% will be with 'VALUE3' o

Re: [SQL] [despammed] question about index

2004-12-16 Thread Bruno Wolff III
On Thu, Dec 16, 2004 at 12:01:39 +0100, Andreas Kretschmer <[EMAIL PROTECTED]> 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