Viewing information about a text index in the database (SQL)

Administrators can view text index terms and settings in Interactive SQL.

Prerequisites

You must have DBA authority or be the owner of the text index.

Context and remarks

Many.

 View text indexes in the database (SQL)
  1. Connect to the database.

  2. Call the sa_text_index_stats system procedure, as follows:

    CALL sa_text_index_stats( );

Results

The text index is displayed.

Next

When a text index is created, the current database options are stored with the text index. To retrieve the option settings used during text index creation, execute the following statement:

SELECT b.object_id, b.table_name, a.option_id, c.option_name, a.option_value
FROM SYSMVOPTION a, SYSTAB b, SYSMVOPTIONNAME c
WHERE a.view_object_id=b.object_id
AND b.table_type=5;

A table_type of 5 in the SYSTAB view is a text index.

 See also