Using XML Indexes : XML Index « XML « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. XML
3. XML Index

3>
4> CREATE TABLE dbo.Book(
5> BookID int IDENTITY(1,1) PRIMARY KEY,
6> ISBN char(10) NOT NULL,
7> BookName varchar(250) NOT NULL,
8> AuthorID int NOT NULL,
9> ChapterDESC XML NULL)
10>
11>
12> CREATE PRIMARY XML INDEX idx_XML_Primary_Book_ChapterDESC
13> ON dbo.Book(ChapterDESC)
14> GO
1>
2> CREATE XML INDEX idx_XML_Value_Book_ChapterDESC
3> ON dbo.Book(ChapterDESC)
4> USING XML INDEX idx_XML_Primary_Book_ChapterDESC
5> FOR VALUE
6> GO
1>
2> SELECT name, secondary_type_desc
3> FROM sys.XML_indexes
4> WHERE object_id = OBJECT_ID('dbo.Book')
5>
6> drop table dbo.book
7> GO
name
         secondary_type_desc
------------------------------------------------------------------------------------------------------------------------
-------- ------------------------------------------------------------
idx_XML_Primary_Book_ChapterDESC
         NULL
idx_XML_Value_Book_ChapterDESC
         VALUE

(2 rows affected)