yuvipoy (3/11/2014)
GUIDs certainly can be used as clustered indexes, nothing prevents that.
why not if it is not alpha numeric?
Don't understand what you're asking
Then What is the draw back if we use cluster index on GUID column.
From earlier in this thread:
Using a guid for a clustered index produces a very high frequency of page splits which is why the index gets so fragmented.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability