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

Syntax

sa_refresh_text_indexes( )

Remarks

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.

Permissions

DBA authority required

Side effects

Automatic commit

See also

• Full text search
• Text configuration objects
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE statement
• SYSTEXTIDX system view
• sa_text_index_stats system procedure
• sa_text_index_vocab system procedure

Example

The following statement refreshes all text indexes in the database:

CALL sa_refresh_text_indexes( );