Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qwertyjjj
Posting Yak Master
131 Posts |
 Posted - 2007-11-20 : 07:12:23
|
| does adding relationships increase performance or is it only needed for data integrity? |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-20 : 08:55:11
|
| Hm, I've heard sometimes SQL optimiser produces more optimal plans if there are some relationships defined, but I have never seen such cases personaly.On the contrary, usually relatioships slightly decrease the performace, because SQL server needs to verify them (but it is not a good idea to get rid of relationships)When Foreign key is not supported by an index, relationships can have a dramatics impact on the performance |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 17:21:17
|
| It's for data integrity rather performance tuning. |
|
|
|
|
|
|
does adding relationships increase performance?