Post reply

PK - clustered Index

  • September 1, 2011 at 4:50 am

    #256697

    Hi,

    could anyone suggestion please,

    Is it possible to remove PK(primary Key) - clustered Index due to unused index status, If removed this index what will happen unique constraint?

    Thanks

  • September 1, 2011 at 5:13 am

    #1375880

    SQL Server creates a clustered index by default on the PK, but its not necessarily the best it depends on the design of your tables. Each scenario is different

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 1, 2011 at 6:12 am

    #1375904

    You can't remove the index enforcing the primary key constraint without removing the primary key. That may not be a good idea.

    Whether that's the best place for the clustered index or whether the primary key should rather use a nonclustered index is a complex question that can't be answered without details of the table structure, other indexes and how the table is used.

    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

  • September 1, 2011 at 6:27 am

    #1375908

    Hi,

    Thanks for reply....

    Please find attached xls sheet for unused index details and other index used status.

    For the used index values are available for user_seek, user_scan, and unused index values not available at user_seek column.

Viewing 4 posts - 1 through 3 (of 3 total)

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