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.