>>>Hello.
>>>Lets say I have a SET FILTER TO... statement such as
>>>
>>>SELECT client
>>>SET FILTER TO Id = 5321 and SSN = "333224444" and status = "OUT" and IIF(INLIST(state, "AZ", "TN", "WI", "TX", "KY", "FL"), unit+DTOS(dob), "!" + Space(10)) != "!"
>>>
>>>I'm new to VFP. But, I don't know anyone who would write something like this. But I found this line in one of our PRGs.
>>>I think this is slowing our calculation process.
>>>
>>>All the fields are indexed except for STATUS and STATE.
>>>What I want to know is will indexing STATUS and STATE fields help speed this up?
>>
>>
>>If the only values of Status are "IN" and "OUT", an index probably won't help, though you could try.
>>
>>Tamar
>
>No. There are several...I think 8 possible values.

Then a tag will help.

Tamar