Hi Nancy,

But it only works with SELECT, not with the LIST command... And you can't always translate SELECT optimization into xBase optimization, since internally two different engines are used.

Christof

>If you're not familiar with the "SYS(3054) Function - Rushmore Optimization Level" check it out. It's very useful for checking that your code is actually being RM optimized...and to what degree.
>
>>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'