Authenticate with Sybase IQ using an account that has DBA authority or owns the table being indexed.
(Optional) Create a text configuration object for your text index.
Task
From the application menu bar, select View > Open > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects.
Select Text Indexes, click the drop-down arrow that appears to the right, and select New.
In the dialog, select the Sybase IQ server on which the table to be indexed resides.
Select the table.
Enter a name for the text index.
Select columns to include in the text index.
Select a text configuration object.
If the index is on an IQ table in the column store, skip to step 10. If the index is on a table in the catalog store, you see a page that lets you select a refresh type.
Select a refresh type (catalog store tables only). If you select Automatic, set the interval at which the text index refreshes.
Note: If the index is on an IQ table in the column store, it refreshes automatically whenever the data in the underlying table changes.
Select the dbspace in which to store the text index.
(Optional) Enter a comment describing the text index.