>Ed,
>
>Thanks for the response, I actually found that the speed of the SEEK is improved dramatically if you set "DELETED" to "OFF" which is kind of the opposite effect to which I would have expected.
>
>- Aaron.
>
>>>Hi,
>>>
>>>I have over 6,000 records marked for deletion in a certain table and when I tried to perform a SEEK on this table it's slow (a second or 2).
>>>
Try creating an index with your key field + "AND NOT DELETED()". Then perform your search with SET DELE OFF.

>>>Are there any Tips/Tricks for speeding up the SEEK operation on a table containing alot of deleted records (besides doing a PACK)?
>>>
>>
>>SEEK takes you to the first record in the table that matches the key in the specified order; if that record is deleted, it has to proceed to the next record that matches. This can be time-consuming with lots of deleted records, especailly where the current display order is not the SEEK order (eg you seek in a different index than the current ORDER.)
>>
>>You're basically scrod.
>>
>>>I've tried adding an Index on "NOT DELETED()", setting a FILTER, issuing "SET DELETED ON" and using "INDEXSEEK()" to prevent the pointer being moved (in the hopes of speeding up repetative seeks).
>>>
>>>Thanks in advance,
>>>
>>>- Aaron.