General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Dave.
>You mentioned that you also recreate your indexes. Is this something that I should be doing every time I run PACK?
PACK will automatically recreate the indexes for you. However, since it does that based on the definitions of the indexes in the header of the CDX file, that assumes the CDX file is in perfectly good shape. The safe approach is to blow away and recreate the indexes. However, note that this may take significantly longer to perform, especially in VFP 6 SP 3 or later with large tables, because VFP can REINDEX faster than individual INDEX ON commands can be executed.
In 17 years of working with xBase languages, I've never had a problem with PACK, nor have I ever heard of anyone actually having a problem. I suspect this is one of those theoretical issues.
Doug
Previous
Next
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