Subject Varchar Size of Field and Index Performance
Author Lee Jenkins
Hi all,

I am using GUID's for the PK's in my database. I also have a set of domains
that I use across databases and pretty much standard data types.

One of my domains is Varchar(50) and I'm curious if there is any performance
impact since GUID's are 36 chars long.

Is it recommended that I create a specific say Char(36) field for GUID's or is
the difference negligible if I just stick with my standard Varchar(50) domain?

Thanks,

--

Warm Regards,

Lee