Primary key question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Primary key question

Primary key question

Rate Topic

Display Mode

Topic Options

Author

Message

sunny.tjk

Posted Wednesday, January 23, 2013 2:28 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, June 13, 2013 11:11 AM
Points: 267, Visits: 892

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?

Post #1410797

anthony.green

Posted Thursday, January 24, 2013 2:34 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

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.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1411002

« Prev Topic | Next Topic »

Permissions