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).
>>
>>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.