SYSCAT.INDEXOPTIONS catalog view

Each row represents an index-specific option value.

Table 1. SYSCAT.INDEXOPTIONS Catalog View
Column Name Data Type Nullable Description
INDSCHEMA VARCHAR (128)   Schema name of the index.
INDNAME VARCHAR (128)   Unqualified name of the index.
OPTION VARCHAR (128)   Name of the index option.
SETTING VARCHAR (2048)   Value of the index option.