This command displays the settings of an index, showing the following:
Authorization
None.
Command syntax
>>-GET INDEX SETTINGS--table-name-------------------------------> >-----+-----------------------------+-------------------------->< '-HANDLE--handle-column-name--'
Command parameters
Usage notes
If the table is enabled as a multi-index table, this command displays the index settings of all enabled text columns in the table. If a handle-column-name is provided, this command displays the index settings of the specified column.
If the table is a common-index table, the settings of the common index are displayed. If a handle-column-name is provided, it is ignored.
If the table or column is enabled with the index property SECTIONS_ENABLED, the command GET INDEX SETTINGS displays the default model for the index. The default model is the model name you specified during enabling or the first model name in a list of model names. Here is an example:
Current index settings: Index type (INDEXTYPE) = LINGUISTIC Default model (DOCUMENTMODEL) = mymodel Update index option (UPDATEINDEX) = UPDATE Update frequency (UPDATEFREQ) = NONE Node 1 Index directory (DIRECTORY) = /home/user1/db2tx/indices