InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:08:30 GMT20http://www.sqlservercentral.com/Forums/Topic1410797-1550-1.aspxThat is one for testing per your environment as either could produce the best result.I would do a test without the primary key, insert the data, create the primary key and time it.Then truncate the table and import the data again.That way you have a time it takes to import and create the key VS time it takes to import with the key existing, then you can make an informed choice.Thu, 24 Jan 2013 02:34:09 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1410797-1550-1.aspxI'm planning to move data from one database to another on the same server. I've DDL scripts ready to create objects on the new database but I'm not sure if I've to create primary keys before loading the data since I think it will slow up the load. So my question is, do I need to create the primary keys before loading or after loading the data?Wed, 23 Jan 2013 14:28:38 GMTsunny.tjk