--- In firebird-support@yahoogroups.com, "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

combination

> > 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.

Adam