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:
|
| refresh_interval | UNSIGNED INT | The AUTO REFRESH interval, in minutes. |
| last_refresh | TIMESTAMP | The local time of the last refresh. |
| last_refresh_utc | TIMESTAMP WITH TIME ZONE | The UTC time of the last refresh. |
PRIMARY KEY (index_id, sequence)
FOREIGN KEY (index_id) REFERENCES SYS.ISYSOBJECT (object_id)
FOREIGN KEY (text_config) REFERENCES SYS.ISYSTEXTCONFIG (object_id)