Non-clustered indexes stores RID pointers when you have a heap, they
store the CLUSTERING KEY when you have a clusted index. So they have to
be rebuilt to change the pointers.


-----Original Message-----
From: KPS Info
[mailto:mssqldba-ezmlmshield-x685250.[Email address protected]
Sent: Jueves, 31 de Marzo de 2005 12:59 p.m.
To: LazyDBA Discussion
Subject: Clustered Indexes

Is it true that :

When a clustered index is created or recreated, all nonclustered indexes
are automatically recreated?

Thanks for any info.

Greg



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page