Home Forums SQL Server 2012 SQL 2012 - General Create Clustered Index on a Very Large Table (500 GB) RE: Create Clustered Index on a Very Large Table (500 GB)

  • August 8, 2014 at 1:56 pm

    #1736544

    Evil Kraig F (8/8/2014)

    TheSQLGuru (8/7/2014)

    I think this is slightly mis-stated Jeff. While you may not get fragmentation from end-of-index inserts, you certainly can get page LATCH contention, which can be a significant bottleneck to good insert performance in such a scenario.

    Kevin, won't you get LATCH contention at the Extent tail either way?

    Not if you use a non-"tail-end" type key. This is often done in high-volume insert scenarios to spread the latching around the range of values, at least a bit. Hashes or mods or even GUIDs (yes, it hurt just a little bit to say that :w00t:) can be a win in scenarios like that.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service