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