When I drop and recreate a 4Gig index, it is taking forever.

I see low read I/O from the Data Tablespace Disk and low I/O to the Temp Tablespace Disk.

I am running UDB 7.2 on a AIX server.

If the Indexes are smaller then 2 Gig, it flies through... I am guessing there is a tunable parm that I may be able to increase to help...

Any suggestions??????

Your tablespace for the index should be more than twice the size of the index to allow for sorting during the create index operation.

also make sure that your util_heap_sz is large enough, and if you can turn parallelism on, you can really speed it up even more.

SORTHEAP(database config) and indirectly SHEAPTHRES(db mgr config which limits SORTHEAP) have a direct bearing on sorting the indexes; bigger the SORTHEAP, bigger the chains during the SORT, and fewer I/O's to the disk(TEMPSPACE). TEMPSPACe should be on the fastest disk; local rather than a STORAGE system;no raid-5 etc;