If you need the indexes to accomplish the data population efficiently, then create them before. Otherwise, after.
For example, if one of the tables you need to populate depends on data in one of the other tables you are populating, there might be an index that makes that more efficient. In that case, creating that index might be a good idea.
But for bulk-loading tables, creating the indexes afterwards is definitely faster and better.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon