Adding an index

An index can be added automatically for primary, unique or foreign constraints. When
an index is linked to a key, Open ModelSphere will make sure that the index
column’s elements are always synchronized with the corresponding key composition.
In order to generate an index, you have to select one of the keys (primary, unique or
foreign), right-click it and choose Add index from the pop-up menu.
Otherwise, you can select the table descriptor > Add > Add index. Then select the
index > Properties > Indexed elements > Add (to add elements in the index). You
will need to select a blank space for the window to open. You can now choose and
add your elements.
In the diagram, the prefix X will appear to indicate the index.