Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only