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	You must have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes. View text index properties – none. Rename a text index – you must have one of: DBA authority REFERENCE permission on the underlying table You own the underlying table being indexed Move a text index – you must have 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 – you must have one of: DBA authority You own the underlying table being indexed
SAP Sybase IQ 16.0	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 View any text index property page – none. Rename a text index – you must have 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 – you must have 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 – you must have the MANAGE ANY STATISTICS system privilege. You must also have 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

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

View text index properties – none.

Rename a text index – you must have one of:

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

Move a text index – you must have 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 – you must have one of:

DBA authority
You own the underlying table being indexed

SAP Sybase IQ 16.0

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

View any text index property page – none.

Rename a text index – you must have 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 – you must have 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 – you must have the MANAGE ANY STATISTICS system privilege. You must also have 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 must be 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, expand IQ Servers > Schema Objects, and then select Text Indexes.
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, SAP 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.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.