Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns statistical information about the text indexes in the database.
Use 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.
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).
The following statement returns statistical information for each text index in the database:
CALL sa_text_index_stats( );