Same thing. For fastest performance, be sure to have an index on ID and on Deleted().
>A table contains 1,000 records. 50 records have been marked for deletion and 100 records have a value 'X' in the id field. IF the following commands are executed separately, which one can enhance performance? Why?
>
>1. LIST FOR id = 'X' AND DELETED()
>
>2. LIST FOR DELETED() AND id = 'X'
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