Home Forums SQL Server 2008 SQL Server 2008 - General drop clustered index ,rebuild or reorganize non clustered index? RE: drop clustered index ,rebuild or reorganize non clustered index?

  • January 2, 2014 at 10:33 am

    #1676998

    Jeff Moden (1/2/2014)

    Markus (1/2/2014)

    I guess the question remains... why would you drop a clustered index on a table?

    I can see doing it only if you need to change the keys for something like partitioning but, even then, I believe a REBUILD will do it. Other than that, I can't see doing it.

    Point well taken though.

    @SQL Crazy Kid,

    Why do you need to drop the Clustered Index?

    Hello,

    My post is to measure the impact in case we drop and recreate CIX either with new combosit key or change of key.I was in assumption that all the NIX associated with the CIX will reorganize instead of rebuild [Reorganizing an index uses minimal system resources].