Refreshing a text index

Administrators can refresh text indexes in Sybase Central to update the data in the text index. Refreshing a text index causes it to reflect any data changes that have occurred in the underlying table.

Prerequisites

You must have DBA authority or be the owner of the table on which the text index is built.

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

Context and remarks

Many.

 Refresh a text index (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, click Text Indexes.

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

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

Results

The text index is refreshed.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1