January 23, 2013 at 2:28 pm
I'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?
January 24, 2013 at 2:34 am
That 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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply