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.
To refresh a text index, you must be the owner of the underlying table or have one of the following privileges:
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.
Context and remarks
Text indexes for materialized views are refreshed whenever the materialized view is updated or refreshed.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|