|
|
Guidelines to be adhered when creating a XML index
|
Guidelines to be adhered when creating a XML
index - March 14, 2009 at 15:50 PM by Amit Satpute
What are the guidelines to be adhered when creating a XML
index?
-
A primary index can be created on only one XML data type column.
-
Primary keys of a table cannot be modified if a primary key exists on a same
table.
-
A table cant have XMl primary index and non-XML index with the same name.
-
A table on which a primary key is being created needs to have a clustered index
created on it.
-
An XML index needs to be dropped before changing datatype column from typed to
untyped.
-
Indexes cannot be created on XML type or views with XML type column.
-
XMl index should be created on the same file or partition as the table.
|
|
|
|
|
