General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
PACK has always done a REINDEX - it has to.
This is because it physically eliminates records, thus changing the positions of records, rendering (old) record numbers in indexes invalid.
PACK actually copies (undeleted) records to a new temporary table, REINDEXes that new table, and deletes the old table and renames te temporary ones to the original nems.
>Hello All.
>
>I’ve noticed that during packing VFP70 does an implicit reindexing. In this regard, is it a _complete_ reindexing (i.e. DELETE TAG ALL, INDEX ON …) or a mere emulation of REINDEX command. I am asking because after packing a do a complete reindexing anyway, and now i am wondering if it is really nesessary.
>
>TIA
>Kamil.
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