Post reply

Delete clustered primary keys

  • November 13, 2008 at 6:33 am

    #196202

    Hi All,

    I currently have a database where indexes need to be rebuild. Some of the tables have clustered primary key constraints and these have relationships with other tables in the database.

    Will it be a good idea to drop the constraints on the database and then drop the clustered primary key indexes on the tables.

    I suggested to the developer that we reorganize the clustered indexes instead of rebuilding them.

    Any suggestions?

    Regards

    IC

  • November 13, 2008 at 6:42 am

    #898034

    Imke Cronje (11/13/2008)

    Will it be a good idea to drop the constraints on the database and then drop the clustered primary key indexes on the tables.

    I don't think it is needed

    I suggested to the developer that we reorganize the clustered indexes instead of rebuilding them.

    Why NO to rebuild? Is your logical scan fragmentation less than 10%?? if so you can just reorganize.

    If its more than or in the range of 20-30+ % then rebuilding is good.

    Any suggestions?

    I would say rebuild the clustered index, should not be that long. You can schedule it to midnight also update statistics with full scan

    [/quote]

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

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

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