Walter Meester
HoogkarspelNetherlands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only