Additional indexing can be established here in order to optimize the system’s performance. On the Indexes Tab (Fig. 6-8) you can enter any combination of columns for each additional index that is often used in referencing and drill down.

Each additional index, represented by a node in the Indexes Pane, will have a unique name defining the purpose of this field combination.

This parameter allows you to determine where the Index will be stored. It is Databasespecific and works differently with various DB types. Please consult your DBA prior to using this feature.

If Yes is checked, the Index will be regarded as Unique.