>Hi Rich, > >There're 2 reasons to delete all indexes before adding a lot of data to a table: > >
Performance. The existing indexes have to be updated during append which will slow down the process. >
Index bloat. See http://fox.wikis.com/wc.dll?Wiki~CDXBloat > >>We have a huge file which regularly approaches the 2GB limit. The system is being rewritten to use an Oracle back-end but needs regular TLC in the interim. >> >>The procedures here are to >> >>1. Save the index tags to an array >>2. Copy the older records to a temp table >>3. Delete those records >>4. Delete all the index tags >>5. PACK the tables (should bring the size down from 1.9 GB to 1.6 GB) >>6. Rebuild each index tag separately from the array >> >>The archive file is also growing rather large (1.25 GB at the moment). Prior to APPENDing from the temp table, they also DELETE the index tags and then rebuild them. >> >>There are anywhere from 10 to 30 tags involved on the tables involved in this process. >> >>Is there any performance or safety reason for doing this? Are there any reasons to avoid doing something like this?
