Home Forums SQL Server 2005 Administering disable /enable indices? Is it worth it? RE: disable /enable indices? Is it worth it?

  • October 6, 2013 at 8:07 pm

    #1656211

    GilaMonster (10/6/2013)

    Drop the clustered index = recreate the entire table and rebuild all nonclustered indexes

    Create the clustered index = recreate the entire table (again) and rebuild all nonclustered indexes (again)

    Given that, what do you think?

    Got it, what if PK is not a clustered index, so basically PK is a non-clustered index. Can we disable PK which is nc index?thanks