General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
#1 Replacing PACK? --- #2 INDEX vs REINDEX? (file bloat)
Advice from 'Hackers' and others says to copy,rename,delete rather than pack (safer) - and index rather than reindex (to control file bloat). Comments?
Can someone point me to FAQ or code sample that specifically handles a copy,rename,delete of a table within a database that has multiple tags?
I want to be sure I understand the nuances of renaming and moving tables around when they are members of a dbc.
Also looking for code example that replaces/automates index so that it functions like a reindex in a dbc table with mutiple tags.
My table will frequently change reccount from 1k to 100k, so recycling deleted records doesn't seem to be the best way to go.
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