Indexes Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Index Editor lets you manage columns and properties, and view space details for an index.

Note: IBM DB2 for Windows, Unix, and Linux, lets you segregate Include columns; columns that are to be part of the index but not part of the unique key.

To edit an index

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you manage columns that make up the index. On opening, this tab shows the existing columns. 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.


Lets you work with properties in the following categories:


Lets you view the Defined By property. Lets you set the Index Type (UNIQUE or NONUNIQUE), specify the index as Clustered, Allow Reverse Scans, and Compression.


Lets you set Percent Free and Minimum Percent Used settings.

Include Columns

Lets you Include columns that are to be part of the index but not part of the unique key. On opening, the tab shows a listing of the Include columns currently defined as part of this index. Optionally, take one of the following actions:

Click the New button to add a new column to the index.

Select an existing column and click the Delete button to delete that column.


Lets you view the following property groups:


Make Unique, System Required, Total Keys, Page Fetch Pairs, and Distinct Keys


Index Level, Cluster Ratio, Cluster Factor, Leaf Pages, Sequential Pages, and Density


First Key, First 2 Keys, First3 Keys, First 4 Keys, and Full Keys


For details on using this tab, see Adding a Comment to an object.


For details on using this tab, see Working with Privileges and Permissions.

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.