Creating an Index in Operations Navigator Database

In Operations Navigator, you can add an index to a new table, or you can add an index to an existing table.

Adding an Index to a New Table in Operations Navigator Database

To add an index to a new table in Operations Navigator, complete the following steps:

1. Follow the instructions for Creating a Table in Operations Navigator Database.
2. On the New Table dialog, click the Indexes tab.
3. On the Indexes page, click the New button.

For more information about indexes, see DB2 UDB for AS/400 SQL Programming Concepts and DB2 UDB for AS/400 SQL Reference .

Adding an Index to an Existing Table in Operations Navigator Database

To add an index to an existing table in Operations Navigator, complete the following steps:

1. In the AS/400 Operations Navigator window, expand the system you want to use.
2. Expand Database.
3. Expand Libraries.
4. Click the library that contains the table in which you want to add an index.
5. In the detail pane, right-click on the table in which you want to add an index and select Properties.
6. Click the Indexes tab.
7. On the Indexes page, click the New button.

For more information about indexes, see DB2 UDB for AS/400 SQL Programming Concepts and DB2 UDB for AS/400 SQL Reference .