Re: Loading Tables From Unload Files

In article <40ifhr$t1o@cssun.mathcs.emory.edu>, pmwages@cais.cais.com says... > > 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 > I prefer to create indexes after loading. Only difference will be the speed. You can create indexes after loading. >************************************************************************* ***** >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. >>