After you have enabled an XML column and created the side tables, you can index the side tables. Side tables contain the XML data in columns you specified while creating the DAD file. Indexing these tables helps you improve the performance of the queries against the XML documents.
Use the DB2 CREATE INDEX command.
Example:
The following example creates indexes on four side tables:
DB2 CREATE INDEX KEY_IDX ON ORDER_SIDE_TAB(ORDER_KEY) DB2 CREATE INDEX CUSTOMER_IDX ON ORDER_SIDE_TAB(CUSTOMER) DB2 CREATE INDEX PRICE_IDX ON PART_SIDE_TAB(PRICE) DB2 CREATE INDEX DATE_IDX ON SHIP_SIDE_TAB(DATE)