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( );
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|