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