Each row represents an index exploitation.
Table 109. OBJCAT.INDEXEXPLOITRULES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FUNCID | INTEGER |
| Function ID. |
| SPECID | SMALLINT |
| Number of the predicate specification in the CREATE FUNCTION statement. |
| IESCHEMA | VARCHAR(128) |
| Qualified name of index extension. |
| IENAME | VARCHAR(18) |
| |
| RULEID | SMALLINT |
| Unique exploitation rule ID. |
| SEARCHMETHODID | SMALLINT |
| The search method ID in the specific index extension. |
| SEARCHKEY | VARCHAR(320) |
| Key used to exploit index. |
| SEARCHARGUMENT | VARCHAR(1800) |
| Search arguments used in the index exploitation. |