• yuvipoy (3/11/2014)


    Then why the column can not be as cluster index?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass