>Is there a general rule on how often tables should be packed and reindexed? I have an app with 20+ tables, and four of them are fairly sizeable relative to the others (about 90,000 records). There are many inserts and deletes to these four tables (200+ inserts and 50+ deletes per week).
>
>Thanks for any information!
>
>John.
I tell my users to run the indexing "once a week or after a power out". Just in case - it doesn't last long, anyway.