Indexes Editor (IBM DB2 LUW)

Go Up to [[IBM DB2 for Linux, Unix, and Windows Object Editors{{#if:||{{{2}}}}}]]

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
Columns	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.
Properties	Lets you work with properties in the following categories:
	Attributes	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.
	Storage	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.
Space	Lets you view the following property groups:
	Attributes	Make Unique, System Required, Total Keys, Page Fetch Pairs, and Distinct Keys
	Statistics	Index Level, Cluster Ratio, Cluster Factor, Leaf Pages, Sequential Pages, and Density
	Cards	First Key, First 2 Keys, First3 Keys, First 4 Keys, and Full Keys
Comment	For details on using this tab, see Adding a Comment to an object.
Permissions	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.