>>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.
>
>Yes, since both Status and State are mentioned in the Set Filter line, index tags on these fields will speed things up. But be aware that you should only index them ONCE, and never again. Like this:
>
>
Use Client exclusive
>Index on Status tag Status
>Index on State tag State
>These lines will create (or add to) a file called Client.cdx, and this file will be automatically "used" and updated hereafter.
Thank you.
I would have created the indexes and tested it, but I have no access to real live data. I only have a fraction of what may be at the client site.