SYSCAT.INDEXXMLPATTERNS catalog view

Each row represents a pattern clause in an index over an XML column.

Table 1. SYSCAT.INDEXXMLPATTERNS Catalog View
Column Name Data Type Nullable Description
INDSCHEMA VARCHAR (128)   Schema name of the logical index.
INDNAME VARCHAR (128)   Unqualified name of the logical index.
PINDNAME VARCHAR (128)   Unqualified name of the physical index.
PINDID SMALLINT   Identifier for the physical index.
TYPEMODEL CHAR (1)  
  • Q = SQL DATA TYPE (Ignore invalid values)
  • R = SQL DATA TYPE (Reject invalid values)
DATATYPE VARCHAR (128)   Name of the data type.
HASHED CHAR (1)   Indicates whether or not the value is hashed.
  • N = Not hashed
  • Y = Hashed
LENGTH SMALLINT   Length if DATATYPE = 'VARCHAR' and HASHED = 'N'; precision if DATATYPE = 'DECIMAL'; 0 otherwise.
SCALE SMALLINT   Scale if DATATYPE = 'DECIMAL'; 0 otherwise.
PATTERNID SMALLINT   Identifier for the pattern.
PATTERN CLOB (2M) Y Definition of the pattern.
Note:
  1. When indexes over XML columns are created, logical indexes that use XML pattern information are created, resulting in the creation of physical B-tree indexes with key columns generated by the database manager to support the logical indexes. A physical index is created to support the data type that is specified in the xmltype-clause of the CREATE INDEX statement.