Returns statistical information about the text indexes in the database.
Syntaxsa_text_index_stats( ) RemarksUse the sa_text_index_stats system procedure to view statistical information for each text index in the database. The following table describes the information returned by sa_text_index_stats.
| Column name | Type | Description |
|---|---|---|
| owner_id | UNSIGNED INT | ID of the owner of the table |
| table_id | UNSIGNED INT | ID of the table |
| index_id | UNSIGNED INT | ID of the text index |
| text_config_id | UNSIGNED BIGINT | ID of the text configuration object referenced by the index |
| owner_name | CHAR(128) | Name of the owner |
| table_name | CHAR(128) | Name of the table |
| index_name | CHAR(128) | Name of the text index |
| text_config_name | CHAR(128) | Name of the text configuration object |
| doc_count | UNSIGNED BIGINT | Total number of indexed column values in the text index |
| doc_length | UNSIGNED BIGINT | Total length of data in the text index |
| pending_length | UNSIGNED BIGINT | Total length of the pending changes |
| deleted_length | UNSIGNED BIGINT | Total length of the pending deletions |
| last_refresh | TIMESTAMP | Date and time of the last refresh |
The pending_length, deleted_length, and last_refresh values are 0 for IMMEDIATE REFRESH text indexes.
For MANUAL REFRESH text indexes, you can use doc_length, pending_length, and deleted_length to decide whether to refresh the text index, and the type of refresh to perform (rebuild vs. incremental).
PermissionsDBA authority
Side effectsNone
See also ExampleThe following statement returns statistical information for each text index in the database:
CALL sa_text_index_stats( ); |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |