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?

TIA.