Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Index??
Message
De
16/05/2007 11:11:53
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Primary Index??
Divers
Thread ID:
01226028
Message ID:
01226028
Vues:
71
I have been reading some text which indicates that to index an XML column, there must be a clustered index on the Primary Key of the table, and that the index on the XML column must be a "Primary Index".

I understand a primary key, and I understand that a primary key can be a clustered or not-clustered index. An index can also be defined on the primary DB file, but I have not heard of 'Primary Index' before, and I am unable to pull anything up in a search for the whole term in BOL. Is there such a thing?

Your help is greatly appriciated.
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform