>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.
Unless you have metadata for your tables,
copy, delete, rename is a hassle. You have RI issues, relations to other tables, PKs, and FKs as well. Recreating indexes from scratch instead of reindex is much simpler and easier to implement.
If you are looking to go this route, I strongly suggest you determine how much your time is worth and multiply this by the number of hours you think it would take to develop this code. Then go look at the price of Stonefield Database Toolkit which will do this for you, and more.
Mark McCasland
Midlothian, TX USA