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.
Aaron Young
Red Wing Software, Inc.