February 26, 2004 at 2:38 am
If 2 tables are designed to not have a relationship, but are joined in a select query, is there any performance criteria involved when the query is run by not having the relationship. I suppose the question is whether a defined relationship is purely concerned with data integrity and consistency etc. or does it affect the execution plan when compiling?
Any comments?
February 26, 2004 at 3:29 am
Relationship does not directly affect performance.
Primary key by default will have unique index which has big impact on performance, but one can put unique index without primary key to take some effect.
February 26, 2004 at 3:42 am
I'm ok with indexing strategies etc, it's purely concerning the defined/not defined relationship prior to creating a JOIN.
February 26, 2004 at 4:02 am
It shouldn't make a difference. AFAIK relations are for data integrity and don't have an effect on JOINs.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 26, 2004 at 7:03 am
Not implications on reading but on Updates,Inserts and triggers abilities they do have impact because are supposed to guarantee data integrity!
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply