Re: dbexport/dbimport problems

dbexport/dbimport creates indexes before loading data so you don't see the problem you outline. My original comment was about the use of LOAD on tables that span multiple disks. If a load is done before all the indexes are created, you end up with all index pages on the last chunks. This will degrade performance because these last chunks will be a bottleneck. David W Chan Objective Research Ltd dwc@cix.compulink.co.uk