I need to drop indexes on a table over 500mil records, I wandering is it better to drop the indexes the following sequence
non-clustered indexes -> primary -> clustered index
or the following
Clustered index -> primary -> non-clustered indexes
I would assume the first one will be slower?
Is my assumption correct?