Each row in the SYSTEXTIDX system view describes one text index, for use with the full text search feature. The underlying system table for this view is ISYSTEXTIDX.
For more information about the full text search feature, see Full text search.
| Column name | Column 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 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)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |