Monday, December 24, 2012

SQL Index Drop and Create Order


Always drop the Non Cluster Index first as it has reference to Cluster Index.
If Cluster Index was removed first, non Cluster Index would have to be updated on cluster index removal.
When you build index, first build the Cluster Index and then Non Cluster.

Note: All NON Cluster Indices can be build simultaneously once Cluster Index is created.

No comments: