Refreshes all text indexes defined as REFRESH MANUAL or REFRESH AUTO.
The sa_refresh_text_indexes system procedure refreshes all text indexes defined as REFRESH MANUAL or REFRESH AUTO. It does not refresh text indexes defined as IMMEDIATE REFRESH (the default) because changes to those indexes are made as soon as data is changed in the underlying table.
DBA authority required
The following statement refreshes all text indexes in the database:
CALL sa_refresh_text_indexes( );
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|