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.
Contexte et remarques
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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|