Re: Loading Tables From Unload Files

dwoltkamp@aol.com (DWoltkamp) wrote: >I wonder if I might be able to get a definitive answer to a question that >has been making the rounds for a long time? >Is is better to load tables without indexes and create the indexes after >the load, or load the table with indexes in tact? >I'm not concerned with the speed of loading tables, but more concerned >with performance after the load is completed. >Any answers and opinions are welcome... Thank you. Yes, it makes a difference. If index(es) are created before loading the data and index nodes will be fragmented and cost you performance. This does not happen if you create indexes after. Indexing after creates nice contiguous data and index files. This is more than just an opinion, I got this from Informix. -------------------------------------------------------- Rob McAllister rmcall@on-ramp.ior.com Spokane, WA "On all good programmers a little core must dump"