Re: Loading Tables From Unload Files

My preference is to create the index before the load . I don't think makes much difference though ecept it does save some time. Do the same thing with Oracle. ciao p ****************************************************************************** Peter Wages VSE Corporation 2760 Eisenhower Ave Alexandria, Virginia pmwages@cais.com Work: (703) 329-2626 Home: (202) 244-3511 Anywhere is walking distance, if you have the time ****************************************************************************** On 11 Aug 1995, 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. >