>>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.

Thanks Dragan!

I've been on the "once a week" schedule for these tables and everything seems fine but I wanted to query the experts.

Thanks again,


John