Subject Re: Indexes on fields
Author Adam
--- In, "Ed Dressel" <Dressel@...> wrote:
> > I would create 3 indices, one for each column, FB does a good job
> > combinning then to create "on the fly compound indices".
> >
> > If I have problems with this approach then I would try the
> > of the pairs.
> Thanks.
> How would I know if there is a problem? The DB sits on a server and I
> don't get watch it under pressure.

Using test data in a test environment rather than on your guinea pigs
/ customers.

But (from your other post) with only 7000 records, you will not notice
too much the difference between two combined indices and a compound index.