Defining Indices

Select a table in a project and access JD Edwards EnterpriseOne Table Design Aid.

1. Click the indices form so that it is active, and the indices menu is visible.

2. From the indices menu, select Add New.

   You can also drag indices from the Columns form onto the Indices form.

   The index description is Untitled, and the index is marked with a key icon that displays the letter P to indicate a primary index.

3. Enter a name for the index, and press Enter.

4. On the Columns form, drag appropriate columns to the index.

   A unique index is marked with a single key. You can right-click the index and select Unique from the Index menu to toggle the unique status. The Unique Primary Index cannot be changed to a non-unique status.

5. Right-click the data item and select or clear the Ascending option to indicate the sort order of ascending or descending for an index column.

   An upward-pointing arrow indicates that the index column is sorted in ascending order.