Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing PK from non-clustered to clustered
Message
De
07/07/2016 08:51:50
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01637980
Message ID:
01638021
Vues:
58
>
>The ever increasing identity column is the best candidate for the clustered PK. You made a right switch, by default SQL Server makes PK column clustered. Perhaps you originally somehow made it non-clustered.

Just to clarify - if you create an identity column and make it a primary key, SQL Server (by default) will make it a clustered index.

But simply making a column an identity column (without giving the PK designation) doesn't make it a clustered index (actually no index is created)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform