Creating the Foreign Key after the table being loaded

[manmaria]

Created a FK after a 1.5million records table being loaded. Is there any draw backs for doings this? Do I need to rebuild the indexes? or reindex is automatic after creating the FK?

TIA

 

[mrdenny]

No there is no drawback to doing this. You shouldn't need to rebuild the index after the FK is created.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog