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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br