Adding indexes

You create an index to optimize performance when searching the table using the Find function and to establish uniqueness of table columns.

1. From the List tab, select the object to which you want to add an index, and click the Indexes tab.
2. In the Indexes table, click New Row.
3. In the Index field, specify a value.
4. Optional: To make each column in the index unique, select the Enforce Uniqueness check box.
5. For IBM® DB2® and SQL Server: Select the Clustered Index check box to create a clustered index.
   You can have only one clustered index per table.
6. Specify a storage partition or accept the default value.
7. In the Columns table, click New Row to add a column to the index.
   1. In the Column field, specify an attribute from the selected object.
   2. Optional: In the Sequence field, specify the sequence for the column.
      If you do not specify a value, then the order in which you add columns determines their sequence.
   3. Optional: Select the Ascending check box to have the index searched in ascending order.
      If this field is cleared, the index is searched in descending order.
8. Click Save Object.
   The index status will display Add until you configure the database.