Referential integrity improves performance

I have been told many times by people who dont’ know better (but think they do) that using referential integrity degrades performance as SQL needs to check the constraints when running the queries. I constantly argue the converse but thankfully the nice guys at SQL Server Central have put together this nice little demonstration on how foreign key constraints can actually improve query performance.

I have decided not to write anything additional in this post about it as their article does it so well it needs no additional example or info. Now please stop arguing against this point!

http://www.sqlservercentral.com/articles/Performance/71264/

 

Advertisements

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in SQL Stuff and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s