USE xmldb
GO

CREATE TABLE xml_tab(
	the_id INTEGER PRIMARY KEY IDENTITY,
	xml_col XML)
GO

CREATE PRIMARY XML INDEX xmlidx1 ON xml_tab(xml_col)
GO

-- structural index
CREATE XML INDEX xmls1 ON xml_tab(xml_col)
USING XML INDEX xmlidx1 FOR PATH
GO

-- property index
CREATE XML INDEX xmlp1 ON xml_tab(xml_col)
USING XML INDEX xmlidx1 FOR PROPERTY
GO

-- value index
CREATE XML INDEX xmlv1 ON xml_tab(xml_col)
USING XML INDEX xmlidx1 FOR VALUE
GO