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

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.