Int PK inner join Vs Guid PK inner Join on SQL Server. Execution plan.
- by bigb
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?