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

Filed under:

I just did some testing for Int PK join Vs Guid PK.

Tables structure and number of records looking like that:

alt text

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.

alt text

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

Related posts about sql-server-2008