You can only refresh text indexes that are defined as AUTO REFRESH and MANUAL REFRESH.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the table on which the text index is built.
In the left pane, click Text Indexes.
Right-click the text index and choose Refresh Data.
Select an isolation level for the refresh and click OK.
Connect to the database as a user with DBA authority, or as the owner of the table on which the text index is built.
Execute a REFRESH TEXT INDEX statement.
For example, the following statement refreshes a text index called MarketingTextIndex on the Description column of the MarketingInformation table in the sample database:
REFRESH TEXT INDEX MarketingTextIndex ON MarketingInformation WITH ISOLATION LEVEL SNAPSHOT;
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|