sa_text_index_stats system procedure

sa_text_index_stats( )

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.

Column name	Type	Description
owner_id	UNSIGNED INTEGER	ID of the owner of the table
table_id	UNSIGNED INTEGER	ID of the table
index_id	UNSIGNED INTEGER	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	Local 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).

You must have one of the following system privileges:

MANAGE ANY STATISTICS
CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX
CREATE ANY OBJECT
ALTER ANY OBJECT
DROP ANY OBJECT

None

The following statement returns statistical information for each text index in the database:

CALL sa_text_index_stats( );

sa_text_index_stats system procedure

Syntax

Remarks

Privileges

Side effects

See also

Example