Walter Meester
HoogkarspelPays-Bas
Christof,
>1. LIST FOR id = 'X' AND DELETED()
>2. LIST FOR DELETED() AND id = 'X'
>When you have an index on DELETED() and ID, both should take the same time. If you don't have an index, the second one should be faster, because only in 50 cases the expression ID="X" has to be evaluated.
From the theory you're right, but since the most time would be spend by getting the actual records into memory, in practice there would be no significant difference as it don't take much time to evaluate both of the expressions.
Précédent
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