You can view information about text indexes in the database using Sybase Central, or by using a SQL statement.
Connect to the database as a user with DBA authority or as the owner of the text index.
In the left pane, click Text Indexes.
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.
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.
Connect to the database as a user with DBA authority, or as the owner text index.
Call the sa_text_index_stats system procedure, as follows:
CALL sa_text_index_stats( );
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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|