Modifying the Properties of a Text Index

Display and change the properties of a text index for a Sybase IQ table (column store) or a catalog store table (row store).

Prerequisites

Create a text index.
Authenticate with Sybase IQ using an account that has DBA authority or owns the table being indexed. (If you do not have authority to modify properties, Sybase Control Center displays the properties dialog in read-only mode.)

Task

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 pages of the Text Index Properties dialog (General and Columns) to display properties.

You can change the name, comment, and refresh type (unless it is set to Immediate). If refresh type is set to Automatic, you can also set the refresh interval and units.

Some properties cannot be modified. These include, on the General page, the text index’s type, table, dbspace, text configuration object, and (if it is set to Immediate) refresh type. You cannot change anything on the Columns page.
Click Apply to save your changes and keep editing, or click OK to save and close the properties dialog.