Post reply

Drop Clustred index on primary key

  • July 1, 2010 at 12:52 am

    #224355

    Hi Experts,

    How can I drop clustered index on primary key.

    what will be the impact. Clustered index is not used. This is index creted on primary key automatically.

    Thanks in advance.

  • July 1, 2010 at 1:36 am

    #1187487

    You will have to drop the primary key and re-create it nonclustered.

    The primary key and the associated index have to live together and cannot be dropped/created separately.

    -- Gianluca Sartori

  • July 1, 2010 at 7:03 am

    #1187640

    The DROP INDEX statement does not apply to indexes created by defining PRIMARY KEY or UNIQUE constraints. To remove the constraint and corresponding index, use "ALTER TABLE" with the DROP CONSTRAINT clause.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • July 1, 2010 at 7:06 am

    #1187642

    2005_DBA (7/1/2010)

    Hi Experts,

    How can I drop clustered index on primary key.

    what will be the impact. Clustered index is not used. This is index creted on primary key automatically.

    Thanks in advance.

    How did you determine that the clustered index is not used?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

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

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