Create an Index

How To:

To create an Index, follow the steps below:

Step

Action

See Also

1

Ensure that the column(s) to be used in the index have already been defined in the table.

 

2

Right-click on the required table either in a diagram or in the Project Browser.

 

3

Select the Operations context menu option

The Operations dialog displays.

 

4

Add an operation with a name such as IDX_CustomerID. The IDX_ prefix is optional, but helps to identify the operation.

 

5

In the Stereotype field for the operation, select index (check and unique are also supported).

 

6

Click on the Column tab.

 

7

Select the required columns from the Columns drop-down list in the required order

 

8

Click the Save button to save changes.

 

Example:

In the example below, the Order element shows how an index looks in a diagram:

IndexesTriggers

Notes:

  • The unique characteristic applied to a single column ensures that no two data values in the column can be identical. The unique stereotype applied to an index ensures that no two combinations of values across a set of columns can be identical

Learn more: