SYSCAT.INDEXEXPLOITRULES catalog view
Each row represents an index exploitation rule.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
FUNCID | INTEGER | Identifier for the function. | |
SPECID | SMALLINT | Number of the predicate specification. | |
IESCHEMA | VARCHAR (128) | Schema name of the index extension. | |
IENAME | VARCHAR (128) | Unqualified name of the index extension. | |
RULEID | SMALLINT | Identifier for the exploitation rule. | |
SEARCHMETHODID | SMALLINT | Identifier for the search method in the specific index extension. | |
SEARCHKEY | VARCHAR (640) | Key used to exploit the index. | |
SEARCHARGUMENT | VARCHAR (2700) | Search arguments used to exploit the index. | |
EXACT | CHAR (1) |
|