• >As I understand it we only need to rebuild non clustered indexes if they are fragmented.

    As what I understand is that Noncluster index will be pointing to cluster key so if we have to reuild Cluster index then we have to rebuild noncluster index also to point correct cluster key value and page.

    could you please clarify that what i think is right or it is not necessary to rebuild noncluste index even though cluster inde has been reuild.

    Thanks!