How to refresh a text index

You can only refresh text indexes that are defined as AUTO REFRESH and MANUAL REFRESH.

 To refresh a text index (Sybase Central)
  1. 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.

  2. In the left pane, click Text Indexes.

  3. Right-click the text index and choose Refresh Data.

  4. Select an isolation level for the refresh and click OK.

 To refresh a text index (SQL)
  1. Connect to the database as a user with DBA authority, or as the owner of the table on which the text index is built.

  2. 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;

    See REFRESH TEXT INDEX statement.

 See also