Hi acudlip,
quote:
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?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]