Truncating a Text Index

Truncate a text index for a system store (IQ catalog store) table.

Prerequisites

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority ALTER permission on the table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	You must have one of: ALTER ANY INDEX system privilege ALTER ANY OBJECT system privilege ALTER permission on the table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

You must have one of:

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

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.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects, and then select Text Indexes.
Select one or more text indexes from the right pane and either.
- Click the arrow to the right of the name and select Truncate Data, or
- From the Administration Console menu bar, select Resource > Truncate Data.
Note: If the text index is not available for truncating, the Truncate Data option is grayed out.

Tip: Use Shift-click or Control-click to select multiple text indexes.
At the confirmation prompt, click Yes.