Home Forums SQL Server 2008 SQL Server 2008 - General Convert Non Clustered PKs to Clustered RE: Convert Non Clustered PKs to Clustered

  • January 9, 2013 at 1:31 pm

    #1575422

    Robert Davis (1/9/2013)

    GilaMonster (1/9/2013)

    robert.nesta123 (1/9/2013)

    Changing NON CL PK to Clustered can have a negative impact?

    Oh yes, especially if the PK column is not a good one for a clustered index.

    Additionally, the PK index is now larger (potentially much larger) because it contains all columns.

    And so, potentially, are all your nonclustered indexes.

    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