>select * from ranges where alltrim(rfrom)=lvalue
>
>is index used or it is a full scan.
>
The SYS(3054) function is a good way to find out what tags are being used to optimize a query. You turn it out like this:
SYS(3054,11)
Then run your query, and you get output telling you exactly how it's being optimized.
Turn the function off with SYS(3054,0). There are actually several other choices for the second parameter-see Help.
In VFP 7, there's also a third parameter that lets you save the results to a variable rather than just displaying them in the active window. Be forewarned that you need to pass the name of a variable, not the variable itself:
SYS(3054, 11, "cResult")
Tamar
Précédent
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