Editing an Index for a Sybase IQ Table

Edit a Sybase IQ index definition.

Prerequisites 

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.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the tree for a database, expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Expand the Tables folder and the table that contains the index.
  3. Under the Indexes folder, find the index you want to edit.
  4. Right-click the index, and choose Edit.
  5. Edit the General options.
    Table 1. General options
    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.
  6. Edit the Columns options.
    Table 2. Column options
    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.
  7. View the DDL for the index in the DDL tab.

    When you are finished editing the index, close the SQL Anywhere Index Editor page, and save your results.

Sybase WorkSpace executes the DDL to change the index and reports results to SQL Results view.
Related tasks
Creating an Index for a Sybase IQ Table
Dropping an Index for a Sybase IQ Table
Using the Index Advisor

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.