Indexes Wizard (Sybase ASE)

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:
   • Properties panel. For details, see Indexes (Sybase ASE) - Properties.
   • Columns panel. For details, see Indexes (Sybase ASE) - Columns.
   • Partition panel. For details, see Indexes (Sybase ASE) - Partition.
   • DDL View panel. For details, see Previewing the DDL Generated to Create the New Object.
3. Click Execute 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.
Attributes	Provide or select values for the following Sybase options: Index Type Clustered Ignore Duplicate Key Ignore Duplicate Rows Maximum Rows Per Page properties
Storage	Provide or select values for the following Sybase options: Reserve Page Gap Segment Name Fill Factor Prefetch Strategy MRU Replacement Strategy

Indexes (Sybase ASE) - Columns

Select a column from the Columns dropdown, and then 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)

You can open the Sybase ASE Index Partition wizard from the following editors and wizards:

• Indexes Wizard (Sybase ASE)
• Indexes Editor (Sybase ASE)

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

Step	Settings and Tasks
Properties	Select a Locality.
Partition Definitions	Click Define a new partition to open a dialog that lets you provide a name and select a segment. Click New to add values, and then Add the partition definition.

Click Finish when done.