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	Requires one of: DBA authority. ALTER permission on the table being indexed. You own the underlying table being indexed. Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	Requires 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. Also requires: If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes. If the system procedure security model^* of the selected database is set to Invoker, you require one of the following system privileges 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 ^*The system procedure security model of the selected database appears on the General page of database properties.

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

Requires one of:

Also requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

Requires one of:

Also requires:

If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
If the system procedure security model^* of the selected database is set to Invoker, you require one of the following system privileges 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

^*The system procedure security model of the selected database appears on the General page of database properties.

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, select IQ Servers > Schema Objects > Text Index.
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.