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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures

 

sa_refresh_text_indexes system procedure

Refreshes all text indexes defined as MANUAL REFRESH or AUTO REFRESH.

Syntax
sa_refresh_text_indexes( )
Remarks

The sa_refresh_text_indexes system procedure refreshes all text indexes defined as MANUAL REFRESH or AUTO REFRESH. It does not refresh text indexes defined as IMMEDIATE REFRESH (the default) because changes to those indexes are made when data is changed in the underlying table.

Permissions

DBA authority required

Side effects

Automatic commit

See also
Example

The following statement refreshes all MANUAL and AUTO REFRESH text indexes in the database:

CALL sa_refresh_text_indexes( );