Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » Full text search » What is full text search?


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.


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.

Context and remarks

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

  1. In Sybase Central, use the SQL Anywhere 16 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.


The text index is refreshed.

 See also