Subject Re: [firebird-support] Indexes on fields
Author Alexandre Benson Smith
Ed Dressel wrote:
> I have 3 varchar fields that I need to search on--in groups of all 3,
> then in pairs. Do I create indexes on any type of searching I do, or
> create individual indexes on each field?
> Thanks
> Ed Dressel
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.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil