Index properties (DB2 UDB for Linux, UNIX, and Windows or iSeries)

Use the Properties view to modify the properties of a DB2® UDB for Linux®, UNIX®, and Windows® or iSeries™ index.

For more information about DB2 UDB for Linux, UNIX, and Windows or iSeries syntax, see the reference information that is included with the product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Schema Shows the relational schema under which the object was created.
System generated Select to specify that no code is generated for this index during DDL generation. You can specify this option if the database will automatically generate an index.
Dimension Select to specify the index as a dimension. The columns for this index will be available on the Dimensions page in the Table properties. Each column or group of columns can be used to cluster the table data.
Details page
Property Description
Unique Select to specify that the index is a unique index.
Clustered Select to specify that the index is a clustered index.
PCTFree Specify a PCTFREE value.
Key columns Specify columns for the key of the index. You can add, remove, or change the sort order for columns in the list. Click the ellipsis [...] toolbar button above the table to open a window where you can select columns and add them to the list. Select a column and click the arrow toolbar buttons to change the sort order. To delete columns, select a column and press Delete.
Include columns Specify non-key columns to include in the index. You can add, remove, or change the sort order for columns in the list. Click the ellipsis [...] toolbar button above the table to open a window where you can select columns and add them to the list. Select a column and click the arrow toolbar buttons to change the sort order. To delete columns, select a column and press Delete.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback