Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
#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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement