Int PK inner join Vs Guid PK inner Join on SQL Server. Execution plan.
Posted
by
bigb
on Stack Overflow
See other posts from Stack Overflow
or by bigb
Published on 2011-01-05T04:50:18Z
Indexed on
2011/01/05
4:53 UTC
Read the original article
Hit count: 249
sql-server-2008
I just did some testing for Int PK join Vs Guid PK.
Tables structure and number of records looking like that:
Performance of CRUD operations using EF4 are pretty similar in both cases.
As we know Int PK has better performance rather than strings. So SQL server execution plan with INNER JOINS are pretty different
Here is an execution plan.
As i understand according with execution plan from attached image Int join has better performance because it is taking less resources for Clustered index scan and it is go in two ways, am i right?
May be some one may explain this execution plan in more details?
© Stack Overflow or respective owner