SYSCAT.INDEXEXPLOITRULES catalog view

Each row represents an index exploitation rule.

Table 1. SYSCAT.INDEXEXPLOITRULES Catalog View
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)  
  • N = Index lookup is not exact in terms of predicate evaluation
  • Y = Index lookup is exact in terms of predicate evaluation