Hello John,
If you are going to search for matches or use SQL to retrieve the records, the individual indexes will work great, however if you plan to use native VFP data access and wish to display records in the correct order, the compound index is better. Also the compound index will allow you to seek partial matches easier.
Bob
>Hi,
> I have a table which will be search using 4 fields together. I would like to ask, should I create complex index using this 4 fields or create 4 different indexes?
>
>Thank you
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'