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.