Indexes Wizard (Sybase ASE)

From RapidSQL
Jump to: navigation, search

Go Up to Sybase ASE Object Wizards

Like an index in a book, a table index helps you get at the data you want without having to read through the whole table. Indexes can exist on single column or on multiple columns. Indexes appear in the form of B-trees. And, as for books, you can have multiple indexes for a single table.

To create a new index using a wizard:

  1. Open a creation wizard for an index. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Indexes (Sybase ASE) - Properties

When creating or editing an index, this tab/panel lets you work with the following settings:

Setting Description

Table Owner, Table Name, and Name

Select or provide identifying information.


Provide or select values for the following Sybase options: Index Type, Clustered, Ignore Duplicate Key, Ignore Duplicate Rows, and Maximum Rows Per Page properties.


Provide or select values for the following Sybase options: Reserve Page Gap, Segment Name, Fill Factor, Prefetch Strategy, and MRU Replacement Strategy.

Indexes (Sybase ASE) - Columns

Select a column from the Columns dropdown and specify a Sort option.

Use the New button to add more columns to the index. Use the Delete button to remove selected columns from the index.

Indexes (Sybase ASE) - Partition

Click Add to open the Index Partition wizard (Sybase ASE).

Index Partition wizard (Sybase ASE)

The Sybase ASE Index Partition wizard can be opened from the following editors and wizards:

Use the following topics as a guide to understanding and setting the options on this wizard:

Step Settings and tasks


Select a Locality.

Partition Definitions

Click the Define a new partition button to open a dialog that lets you provide a name, select a segment, click the New button to add values, and then Add the partition definition.

When finished, click the Finish button.