Edit a Sybase IQ index definition.
Before you can edit an index, be sure the data server that contains the index is running, and you created and established a connection to it.
Field | Description |
---|---|
Index Name | Enter a name for the index. |
Index Type | Select an index type. Valid values are High Group, High Non-Group, Compare, Word, and Low Fast. |
Unique | Make the index unique. A unique index permits no two rows to have the same index value, including NULL. |
Delimiter String | The delimiter string for the index. |
Max Size of String | The maximum size of the delimiter string. |
Notify Count | Change the number of records. By default, after every 100,000 records are inserted and loaded into indexes, you receive a progress message. To stop these messages, specify a value of 0. |
Dbspace | Specify the type of dbspace in which to place the index. Valid values are IQ_SYSTEM_MAIN, IQ_SYSTEM_MSG, IQ_SYSTEM_TEMP, and SYSTEM. |
Comments | Enter comments for the index. |
Field | Description |
---|---|
Filter Column by Name Pattern | Enter a filter expression for the columns to be displayed in the column list. For example, * lists all columns for the specified table. |
Select the Columns | Select the columns to be used in the index. Use Select All, Deselect All, and Invert Selection to change your current selections. Use Up and Down to change the order of columns listed. |
When you are finished editing the index, close the SQL Anywhere Index Editor page, and save your results.