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,

William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team

Oracle - When you care enough to use the very best!!