Ok, I'm getting conflicting response..someone says that they need to be
rebuilt, and someone else says that they don't. Which is it?

Lets try this again with more detail:
I am adding a clustered index to table that does not have one. All it has
is non-clustered indexes. If I add a clustered index, do I need to
specifically drop and recreate the existing non-clustered one? Or does it do
this automatically?

Thanks!

-----Original Message-----
From: Milton Daniel
[mailto:mssqldba-ezmlmshield-x75380296.[Email address protected]
Sent: Thursday, March 31, 2005 2:47 PM
To: LazyDBA Discussion
Subject: RE: Clustered Indexes

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]





---------------------------------------------------------------------
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