Truncating a Text Index

Truncate a text index for a catalog store table.

Prerequisites

Create a text index for a catalog store table (row store).
Authenticate with Sybase IQ using an account that has DBA authority or owns the table being indexed.

Task

Truncating lets you delete data from a text index without dropping the text index definition. For example, to modify the stoplist for a text index:

Truncate the text index.
Edit the stoplist in the text configuration object associated with the text index.
Refresh the text index to bring in the new stoplist.

If a text index is set to immediate refresh, you cannot truncate it. Instead, drop it and create a new one.

From the application menu bar, select View > Open > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects and select Text Indexes.
In the right pane, select a text index and click the drop-down arrow that appears to the right.
Select Properties.
Select the General page of the properties dialog.
Click Truncate Now to truncate the text index.
If the text index cannot be truncated, the Truncate Now button is grayed out.