Re: alter index

Hi there, A REALY fast way of doing a table defrag without an unload is this. You must have some spare dbspace ( add a cooked chunk if you want and drop it later ) eg table address is fragmented with 2 indexes 1. Create table address_x with same structure 2. insert into address_x select * from address ( You may want to turn logging off or not ) 3. Drop indexe on address 4. create indexes on address_x 5. rename table adress_x to address Unloading tables is SLOWWWWWW. This is much faster AND safer as you can keep the original table for a while if you want , Graham Mitchell