Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-03-26 : 09:46:17
|
| I am importing data from an external source and am creating a table to contain the data.Is it better to create a unique clustered index on the table BEFORE I populate the table or AFTER? |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-26 : 10:04:51
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121345 |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-03-26 : 10:12:00
|
| Thanks, but I'm still a little puzzled over what approach to take, my table holds well in excess of 100 Million rows. |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-03-26 : 10:41:32
|
| Reading through again, it looks like option 2 for me then, thanks. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
|
|
|
|
|
Creating an index