How to view text index info in the database

You can view information about text indexes in the database using Sybase Central, or by using a SQL statement.

 To view text indexes in the database (Sybase Central)
  1. Connect to the database as a user with DBA authority or as the owner of the text index.

  2. In the left pane, click Text Indexes.

  3. To view the terms in the text index, double-click the text index in the left pane, and then choose the Vocabulary tab in the right pane.

  4. To view the text index settings, such as the refresh type or the text configuration object that the index refers to, right-click the text index and choose Properties.

 To view text indexes in the database (SQL)
  1. Connect to the database as a user with DBA authority, or as the owner text index.

  2. Call the sa_text_index_stats system procedure, as follows:

    CALL sa_text_index_stats( );
 To retrieve text index creation options
  • 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