The only supported refresh type for TEXT indexes on Sybase IQ tables is Immediate Refresh, which occurs when data in the underlying table changes. Immediate-refresh TEXT indexes on Sybase IQ 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.
