Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Keys and Clustered Indexes
Message
From
12/01/2001 13:18:50
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00462472
Message ID:
00463087
Views:
12
This is true. If you change the clustered key, all nonclustered indexs (NCI) must be updated. There's nothing that can be done. In general, it's recommended that clustered keys consist of non-volitle data.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform