• Hi acudlip,


    1) drop the non-clustered indexes (takes seconds) - to avoid their rebuild when the clustered index is dropped.

    2) drop the clustered index - takes 6 hours!!

    This is approx equal to the time it takes to build the clustered index - its a big table.

    how do you drop the indexes?

    Via EM or QA?



    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]