Post reply

Removing Foreign Key relations from Production SQL Server :

  • March 8, 2005 at 6:14 am

    #109632

    Hi,

    Someone was telling that removing all the Foreign Key relations from the SQL Server in production environment would enhance the performance. But is it a good idea to remove the Foreign Key relations? Will it affect the data integrity? Or is it based on the assumption that being in Production environment the system might have well tested for data integrity. Can you share your views on this?

    Regards

  • March 8, 2005 at 8:41 am

    #545886

    Enchance Performance ? Probably yes

    Good idea ? No

    Will it affect integrity ? Yes, absolutely

    It must be based on the assumption that the client software that inserts/updates/deletes the database is 100% defect free and runs on a bomb-proof OS that never craps out the client.

    Or it's based on the assumption that you have a 'secondary' production system, which is not the 'system of record' for your business, and which can be rebuilt from the data in another primary system when the inevitable integrity issues arise.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply