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. 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.
Attributes	Provide or select values for the following Sybase options: Index Type, Clustered, Ignore Duplicate Key, Ignore Duplicate Rows, and Maximum Rows Per Page properties.
Storage	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:

• 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 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.