Example: Index XML tag values in a separate field

Given the XML fragment:

<book>
	<title>Graph Theory</title>
	<author>Stewart</author>
	<date>January 14, 2006</date>
</book>

To create an index with the untagged values only, use the statement:

CREATE INDEX books_bts ON books(xml_data bts_lvarchar_ops) 
USING bts(strip_xmltags="yes") IN bts_sbspace;

The index will contain a single contents field:

contents:Graph Theory Stewart January 14, 2006

To create an index that has XML tag fields as well as a field for the untagged values, use the statement:

CREATE INDEX book_bts ON books(xml_data bts_lvarchar_ops) 
USING bts(all_xmltags="yes",include_contents="yes",strip_xmltags="yes") 
IN bts_sbspace;

The index will contain XML tag fields as well as the untagged values in the contents field:

title:graph theory
author:stewart
date:january 14, 2006
contents:Graph Theory Stewart January 14, 2006