IBM Books

XML Extender Administration and Programming

Indexing side tables

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.

Before you begin

The DB2 CREATE INDEX command

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)


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]