DB2 10.5 for Linux, UNIX, and Windows

Database objects associated with XML data indexing

Logical and physical indexes over XML data
When you create an index over XML data, two B-tree indexes are created, a logical index and a physical index.
Other database objects associated with XML columns
There are two indexes associated with XML columns that are internal and system generated. The indexes are represented in the SYSCAT.INDEXES catalog view. In addition, index partitions for data partitioned tables with XML data are represented in the SYSCAT.INDEXPARTITIONS catalog view.
Recreation of indexes over XML data
An index over XML data is recreated under the following circumstances: