Post reply

Insert is Slow

  • March 11, 2014 at 5:07 am

    #1695894

    GilaMonster (3/11/2014)

    GUID ordering is not alphanumeric. There's articles on the web which describe how GUIDs are ordered, not that it usually matters much for users.

    Then why the column can not be as cluster index? why not if it is not alpha numeric?

    Then What is the draw back if we use cluster index on GUID column.

  • March 11, 2014 at 5:18 am

    #1695898

    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

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply