TEXT Index Refresh

The only supported refresh type for TEXT indexes on SAP Sybase IQ tables is Immediate Refresh, which occurs when data in the underlying table changes.

Immediate-refresh TEXT indexes on tables support isolation level 3. They are populated at creation time and every time the data in the column is changed using an INSERT, UPDATE, or DELETE statement. An exclusive lock is held on the table during the initial refresh.