Often I see databases where primary keys are of uniqueidentifier type.
When joining such tables together, did this data type impact on performance of query?
Why prefer uniqueidentifier over integer?
How even SQL represent uniqueidentifier in JOIN clause, is it like varchar with specific length or has some other representation?
Often I am confused with this data type, why use and how is it hard for performance...
Thanks!