SYSTEXTIDX system view

Each row in the SYSTEXTIDX system view describes one text index. The underlying system table for this view is ISYSTEXTIDX.

Column name Data type Description
index_id UNSIGNED BIGINT The object ID of the text index in SYSIDX.
sequence UNSIGNED INT For internal use only.
status UNSIGNED INT For internal use only.
text_config UNSIGNED BIGINT The object ID of the text configuration object in SYSTEXTCONFIG.
next_handle UNSIGNED INT For internal use only.
last_handle UNSIGNED INT For internal use only.
deleted_length UNSIGNED BIGINT The total size of deleted indexed values in the text index.
pending_length UNSIGNED BIGINT The total size of indexed values that will be added to the text index at the next refresh.
refresh_type TINYINT

The type of refresh. One of:

  • 1   MANUAL

  • 2   AUTO

  • 3   IMMEDIATE

refresh_interval UNSIGNED INT The AUTO REFRESH interval, in minutes.
last_refresh TIMESTAMP The time of the last refresh.
 Constraints on underlying system table
 See also