Load/Unload Nuances

Hi Guru's, A question on unloading/loading data. I want to un,oad data from one Informix DB and load it onto another. If time is not a constraint to do this, is it necessary to drop the indices before loading the data ? 2. Is dbload a better way to load data as it also logs the details of rows loaded. 3.Also , is it a good idea to sort the data before loading the data ? My guess is there may be a difference in the indexing process, if data is already sorted. (Although we cannot ensure it always in the real world). Since we can sort data when we migrate, is it a good idea to sort and then load ? Thanks in Advance! and any other ideas are most welcome. Thanks

On 30 Jun 2003 09:22:06 -0700, keepitliteus@yahoo.com (aspiring immigrant) wrote: See below . . . >Hi Guru's, >A question on unloading/loading data. >I want to un,oad data from one Informix DB and load it onto another. >If time is not a constraint to do this, is it necessary to drop the >indices before loading the data ? No, it isn't, but it makes the load more efficient and it allows for a 'cleaner' index as well. >2. Is dbload a better way to load data as it also logs the details of >rows loaded. dbload is OK as it gives you the ability to commit every 'n' rows. > >3.Also , is it a good idea to sort the data before loading the data ? I never have worried about that . . . . . that's what Informix indices are for . . . <G> >My guess is there may be a difference in the indexing process, if data >is already sorted. (Although we cannot ensure it always in the real >world). Since we can sort data when we migrate, is it a good idea to >sort and then load ? Don't know. Probably not much of a difference, as Informix will scan each row anyway for the data needed to create the index.