Index, Primary Key, or Unique Key Properties

This dialog box displays the properties of an index, including several types of "index" such as primary key or unique key. These are objects that can be defined on one or more table columns in Relational Models.

General

Name: Name of the index object.

Long Name: Long name for display purposes.

Engineer: Controls whether the index will be considered during reverse engineering operations. If this option is disabled, this index and its properties are not considered when the relational model is reverse engineered into the logical model

Table: Table containing the column or columns to be indexed.

State: State or purpose of the index: Plain Index, Primary Constraint, Unique Constraint, or Unique Plain Index.

Sort Order Columns: Displays the column names and their sort order in the index.

Index Expression: Indicates whether this is a function-based index, which is an index based on an expression.

Spatial Index: Indicates whether this is a spatial index (with INDEXTYPE of MDSYS.SPATIAL_INDEX).

Generate in DDL: Controls whether the index creation is included when DDL statements are generated to be used to create the database.

Columns

Displays columns that are available to be added to the index definition on the left, and columns that are included in the index definition on the right. You can select columns and use the arrow keys to move them from one side to the other.

Functional

Specification of the expression for a function-based index (if Index Expression is enabled under General properties).

Spatial Properties

Spatial properties for a spatial index.

Constrain to Layer Type: Constrains the index to a specified type of layer.

Geodetic Index: Indicates whether the index is on geodetic or projected data.

Number of Dimensions: Number of spatial dimensions to be indexed. Example: 2 for longitude and latitude

Comments in RDBMS

Comment text to be included in database objects that are generated based on this modeling object.

Impact Analysis

Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.

Comments, Notes, Measurements, Change Requests, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.