Indexes Editor (Sybase ASE)
Go Up to Sybase ASE Object Editors
The Indexes Editor lets you manage columns, properties, and partitions, and view statistics for an index.
To edit an index
- Open an editor on the index. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Columns |
Lets you manage columns that make up the index. On opening, this tab shows the existing columns. For each column, the datatype (and if applicable the precision in brackets) and whether the table definition permits nulls in the target table column. Optionally you can: | |
Change the Sort order of a column. | ||
Click the New button and select a column name from the dropdown, to add a column to the index. | ||
Select a column and click the Drop button to delete the column from the index. | ||
Select a column and use the arrow buttons to reorder the columns in the index. | ||
Properties |
Lets you work with settings in the following categories: | |
Attributes |
Has the Index Type (UNIQUE or NONUNIQUE), Clustered, Ignore Duplicate Key (available with Index Type of UNIQUE), Ignore Duplicate Rows (available with Clustered enabled), Allow Duplicate Rows (available with Clustered enabled), and Maximum Rows Per Page properties. | |
Storage |
Lets you set Reserve Page Gap, Segment Name, Fill Factor, Prefetch Strategy, MRU Replacement Strategy settings | |
Partition |
Lets you work with settings in the following categories: | |
Properties |
Lets you view the Locality (Global/Local), Alignment (Prefixed/Non-Prefixed), Partition Type (including Range-Hash Composite or Range-List Composite), and Subpartition type properties. | |
Columns |
Displays partitioning columns. | |
Partition Definitions |
Displays details for each partition. | |
Statistics |
Lets you view statistics in the following categories: | |
Page Statistics |
Data Pages, Reserved Pages, Used Pages, OAM Page Ratio, and Index Page Ratio. | |
Row Statistics |
Maximum Row Size, Minimum Row Size, Max Size of Non-Leaf Index Row, and Maximum Rows Per Page. | |
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.