Immediate   The database server automatically refreshes this text index immediately after changes to underlying data affect data in the text index. See How to manage text indexes.

Once a text index is created, you cannot change it to, or from, immediate refresh. If either of these changes is required, you must drop the text index and create it again. See ALTER TEXT INDEX statement.

Manual   You must refresh this text index manually; for example, by pressing Refresh Now. Data in manual text indexes can become stale because manual text indexes are not refreshed until a refresh is explicitly requested. See How to manage text indexes.

Automatic   The text index is automatically refreshed using a time interval that you specify. If some data staleness is acceptable, you can choose this refresh type and specify the time interval at which to refresh the text index. A query on a stale index returns matching data as of the last refresh. Rows that have been inserted, deleted, or updated since the last refresh are not returned by the query.How to manage text indexes.

Refresh Now   Click to refresh the text index; you are prompted to specify a consistency with which to refresh the text index. Refreshing a text index also initializes it. See REFRESH MATERIALIZED VIEW statement.

Truncate Now   Click to delete all the rows in the text index and to change the state to uninitialized. See TRUNCATE statement.