Indexes

What is an Index?

An index is a sorted look-up for a table; when it is known in advance that a table must be sorted in a specific order, it is usually worth the small processing overhead to always maintain a sorted look-up list rather than sort the table every time it is required.

In Enterprise Architect, an index is modeled as a stereotyped operation; on generating DDL, the necessary instructions for generating indexes are written to the DDL output.