Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Index??
Message
From
16/05/2007 11:11:53
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Primary Index??
Miscellaneous
Thread ID:
01226028
Message ID:
01226028
Views:
78
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.
Next
Reply
Map
View

Click here to load this message in the networking platform