DB2 Create Index
The DB2 Create Index Tool allows users to visually create indexes.
The Create Index Tool allows users to select a table on which to create an index and then specify the uniqueness of the index as well as the columns that make up the index.
The following is an example of the SQL generated from the Create Index Tool for a DB2 database
CREATE UNIQUE INDEX TESTUSER.IDX_DEPARTMENT ON TESTUSER.DEPARTMENT (DNUMBER, DNAME)