Indexing over XML data is subject to restrictions, including data type support restrictions, concurrency level restrictions, XML list elements restrictions, and index compression restrictions.
Command | Concurrency level | Supported |
---|---|---|
REORG INDEXES ALL FOR TABLE | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
REORG TABLE | Command clause: ALLOW [READ | NO] ACCESS | Yes. An index over XML data might exist. |
REORG TABLE INPLACE (at least one index over XML data exists on the table) | Command clause: ALLOW [READ | WRITE] ACCESS | No. |
REORG TABLE RECLAIM EXTENTS | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
Command | Concurrency level | Supported |
---|---|---|
REORG INDEX (on a nonpartitioned index over XML data) | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
REORG INDEXES ALL FOR TABLE CLEANUP|RECLAIM EXTENTS | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
REORG INDEXES ALL FOR TABLE REBUILD1 | Command clause: ALLOW [READ | WRITE] ACCESS | No. |
REORG TABLE | Command clause: ALLOW NO ACCESS (for a partitioned table, the only supported access is ALLOW NO ACCESS) | Yes. |
REORG TABLE INPLACE | Command clause: ALLOW [NO | READ | WRITE] ACCESS | No. For a partitioned table, the INPLACE parameter is not supported. |
REORG TABLE RECLAIM EXTENTS | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
Command | Concurrency level | Supported |
---|---|---|
REORG INDEXES ALL FOR TABLE | Command clause: ALLOW NO ACCESS | Yes. |
REORG INDEXES ALL FOR TABLE CLEANUP|RECLAIM EXTENTS | Command clause: ALLOW [READ | WRITE] ACCESS | Yes. |
REORG INDEXES ALL FOR TABLE REBUILD ON DATA PARTITION1 | Command clause: ALLOW [READ | WRITE] ACCESS | Yes. |
REORG INDEXES ALL FOR TABLE REBUILD1 | Command clause: ALLOW [READ | WRITE] ACCESS | No. |
REORG TABLE | Command clause: ALLOW NO ACCESS (for a data partitioned table, the only supported access is ALLOW NO ACCESS) | Yes. |
REORG TABLE INPLACE | Command clause: ALLOW [NO | READ | WRITE] ACCESS | No. For a data partitioned table, the INPLACE parameter is not supported. |
REORG TABLE RECLAIM EXTENTS | Command clause: ALLOW [NO | READ | WRITE] ACCESS | Yes. |
See the CREATE INDEX statement and REORG INDEX/TABLE command for information about the clauses and options.
For multidimensional clustering (MDC) and insert time clustering (ITC) tables, online index reorganization (rebuild) with ALLOW WRITE ACCESS is not supported.
For a partitioned table, a unique partitioned index over XML data is not supported. If you try to create such index, you will receive error message SQL20303N (SQLSTATE=42990).
Creating indexes on XML columns is also subject to restrictions placed on the native XML data store overall.