Refreshing a text index

Refresh text indexes 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.

Prérequis

To refresh a text index, you must be the owner of the underlying table or have one of the following privileges:

CREATE ANY INDEX system privilege
CREATE ANY OBJECT system privilege
ALTER ANY INDEX system privilege
ALTER ANY OBJECT system privilege
REFERENCES privilege on the table

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

Contexte et remarques

Text indexes for materialized views are refreshed whenever the materialized view is updated or refreshed.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click Text Indexes.
Right-click the text index and click Refresh Data.
Select an isolation level for the refresh and click OK.

Résultat

The text index is refreshed.

Refreshing a text index

Task

See also