Viewing or Modifying Text Index Properties

Display or change the properties of a text index for a main store or catalog store table.

Prerequisites

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	Requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes. View text index properties – None required. Rename a text index – Requires one of: DBA authority. REFERENCE permission on the underlying table. You own the underlying table being indexed. Move a text index – Requires one of: DBA authority. SPACE ADMIN authority. You own the underlying table being indexed and have CREATE permission on the target dbspace. Modify comment on a text index – Requires one of: DBA authority. You own the underlying table being indexed.
SAP Sybase IQ 16.0	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. View any text index property page – None required. Rename a text index – Requires one of: ALTER ANY INDEX system privilege. ALTER ANY OBJECT system privilege. REFERENCE permission on the underlying table. You own the underlying table being indexed. Move a text index – Requires one of: ALTER ANY INDEX system privilege. ALTER ANY OBJECT system privilege. MANAGE ANY DBSPACE One of the following: You own the underlying table being indexed. REFERENCE permission on the table along with one of the following: CREATE ANY OBJECT system privilege. CREATE permission on the target dbspace. Modify a text index comment – Requires: MANAGE ANY STATISTICS system privilege. Also requires one of: ALTER ANY INDEX system privilege. ALTER ANY OBJECT system privilege. CREATE ANY OBJECT system privilege. CREATE ANY INDEX system privilege. COMMENT ANY OBJECT system privilege. You own the underlying table being indexed.

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

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

View text index properties – None required.

Rename a text index – Requires one of:

DBA authority.
REFERENCE permission on the underlying table.
You own the underlying table being indexed.

Move a text index – Requires one of:

DBA authority.
SPACE ADMIN authority.
You own the underlying table being indexed and have CREATE permission on the target dbspace.

Modify comment on a text index – Requires one of:

DBA authority.
You own the underlying table being indexed.

SAP Sybase IQ 16.0

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.

View any text index property page – None required.

Rename a text index – Requires one of:

ALTER ANY INDEX system privilege.
ALTER ANY OBJECT system privilege.
REFERENCE permission on the underlying table.
You own the underlying table being indexed.

Move a text index – Requires one of:

ALTER ANY INDEX system privilege.
ALTER ANY OBJECT system privilege.
MANAGE ANY DBSPACE
One of the following:
- You own the underlying table being indexed.
- REFERENCE permission on the table along with one of the following:
  - CREATE ANY OBJECT system privilege.
  - CREATE permission on the target dbspace.

Modify a text index comment – Requires:

MANAGE ANY STATISTICS system privilege.
Also requires one of:
- ALTER ANY INDEX system privilege.
- ALTER ANY OBJECT system privilege.
- CREATE ANY OBJECT system privilege.
- CREATE ANY INDEX system privilege.
- COMMENT ANY OBJECT system privilege.
- You own the underlying table being indexed.

The SAP Sybase IQ resource is authenticated and running.
You are licensed for the Unstructured Data Analytics option (IQ_UDA).

Task

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 a text index from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Text Index Properties view appears.

View or modify the properties.

Note:

When modifying properties, it is not necessary to click Apply before changing screens.
If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Area	Description
General	Name – The name of the text index. Type – (Read-only) The index type. Table – (Read-only) The table the index uses. Dbspace – (Read-only) The dbspace the text index was created on. Text Configuration Object – (Read-only) The text configuration object used to create the text index. Refresh type – (Read-only) Valid settings are Manual and Automatic. For Automatic, specify the frequency. Last refresh time – (Read-only) The date and time the text index was last refreshed. Refresh Now – If the data has not changed since the last refresh, the refresh date does not change. To force a refresh, truncate the text index, then refresh it. If the text index cannot be manually refreshed, the Refresh Now button is grayed out. Truncate Now – To delete data from a text index without dropping the text index definition. If the text index cannot be truncated, the Truncate Now button is grayed out. Comment – A text field for adding an optional comment about the text index.
Columns (Read-only)	Select a column and click the Details button to view the details of the column.

Area

Description

General

Name – The name of the text index.

Type – (Read-only) The index type.

Table – (Read-only) The table the index uses.

Dbspace – (Read-only) The dbspace the text index was created on.

Text Configuration Object – (Read-only) The text configuration object used to create the text index.

Refresh type – (Read-only) Valid settings are Manual and Automatic. For Automatic, specify the frequency.

Last refresh time – (Read-only) The date and time the text index was last refreshed.

Refresh Now – If the data has not changed since the last refresh, the refresh date does not change. To force a refresh, truncate the text index, then refresh it. If the text index cannot be manually refreshed, the Refresh Now button is grayed out.

Truncate Now – To delete data from a text index without dropping the text index definition. If the text index cannot be truncated, the Truncate Now button is grayed out.

Comment – A text field for adding an optional comment about the text index.

Columns
(Read-only)

Select a column and click the Details button to view the details of the column.

Click OK.