Each row represents a pattern clause in an index over an XML column.
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) |
|
|
DATATYPE | VARCHAR (128) | Name of the data type. | |
HASHED | CHAR (1) | Indicates whether or not the value is hashed.
|
|
LENGTH | SMALLINT | VARCHAR (n) length; 0 otherwise. | |
PATTERNID | SMALLINT | Identifier for the pattern. | |
PATTERN | CLOB (2M) | Y | Definition of the pattern. |
Note:
|