Editing an Index for an ASE Table

Edit an index definition.

1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the Databases folder, and then expand the tree for a database 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.
   Unique	Make the index unique. A unique index permits no two rows to have the same index value, including NULL.
   Clustered	Make the index clustered. In clustered indexes, table data is physically stored in the order of the keys on the index.
   Suspect	Mark the index as suspect.
   Ignore Duplicate Key	If you have chosen to make the index unique, specify whether or not to ignore duplicate keys. The default is No.
   Duplicate Row	If you have chosen to make the index clustered but not unique, specify how duplicate rows are to be treated. You can allow, disallow, or ignore duplicate rows. The default is to not allow duplicate rows.
   Segment	Specify whether to have the index on a default or system segment.
   Fill Ractor	Choose the fill factor setting, which specifies how full Adaptive Server Enterprise makes each page when it creates a new index on existing data. The default is 1.
   Rows Per Page	Specify the number of rows on data pages and the leaf-level pages of indexes. The default is 0.
   Reserve Page Gap	Specify the ratio of filled pages to empty pages to be left during I/O allocation operations. For each specified number of pages, an empty page is left for future expansion of the index. Valid values are 0 - 255. The default is 0.
   Bind to Cache	Specify the cache binding to be used in sorts. The default and only option is currently the default data cache.
   Cache Strategy	Most Recently Used Replacement – replace items in cache with those that have been most recently used. Large Buffer Prefetch – enlarge the buffer for prefetching from cache.
   Data Already Sorted	Specify whether the table data has already been sorted. If the data has already been sorted, the index can be created faster.
   Number of Consumer Processes	Specify a number of processes that are likely to be using the index. The default is 0.
   Statistics Step	Specify the number of steps to generate for the histogram used in query optimizing. The default value is 20.

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. Edit the Partitionoptions.

   Table 3. Partition options

   Field	Description
   Create Local Partitioned Index	Create a local partitioned index. In the table, enter a name or names for the partitions, and choose whether to use the default or system segment for each. Use Delete and Delete All to change your current selections. Use Up and Down to change the order of partitions listed.

8. View the DDL for the index in the DDL tab.

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