>I have a 1 million record file at work that gets 100,000 records added to it each day. Anyways, this is the procedure:
>
>1. Delete the index tags
>2. Add new records
>3. Index on
>
>When the table is indexing, first it does level 3, restarts at level 2 and goes a little further, and then level 1 where it restarts again and finally completes. This is for every index tag. Is this normal and can I just have it INDEX ON normally?
>
>TIA,
Bill,
AFAIK it's normal and Fox balances the B+trees at those levels. Sure for appending this would speed up append time but I wonder if total time appending+reindexing is shorter than just appending w/o removing indexes on a huge table (never had a chance to try).
Cetin