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