Index

An Index is an optional Key that designates a field or combination of fields as a database index. An index can improve the speed of data retrieval, but it also has a performance because it must be updated each time the data is updated. The primary key is automatically indexed.

Characteristics

Characteristics

  

Icon:

Index key

Object type code:

key

Main Development Object?

No

Part of:

Modeled Entity

Contains:

Property

Generalization:

Key

Specializations:

—

Compilation Output:

—

Specialization

Index specializes Key in the following ways:

  • It has the Type property set to Index.