Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on deleted()
Message
From
02/04/2001 02:48:22
Walter Meester
HoogkarspelNetherlands
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00490398
Message ID:
00490841
Views:
12
Glenn,

>The seek mentioned is to access the primary key which, when the record is deleted, is inverted. No additional indexes are required to support this method. It is not necessary to index on deleted to locate deleted records. With this technique only the primary index is needed therefore no extra overhead is experienced.
>
>The number of deleted records is minimized, file sizes can stabilize (depending on the application) and tables do not require packing or reindexing as often.

I agree... This can also be a suitable solution to recycle records.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform