Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement