Re: Loading Tables From Unload Files

In article <40gnln$2nn@newsbf02.news.aol.com> dwoltkamp@aol.com "DWoltkamp" writes: > Is is better to load tables without indexes and create the indexes after > the load, or load the table with indexes in tact? I support the various replys sayin 'load then index' for the reasons mentioned plus another. If the data you are loading is duff (e.g. duplicates where there shouldn't be) and the indexes are in place first, no data gets loaded. If creating them afterwards you can then create the same index without the 'UNIQUE' bit and use it to help speed up finding the culprite row(s). Also, I always load large amounts of data with transaction logging off for more proagmatic reasons - its much faster and won't fall over because transaction logs are full. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================