Previous Topic: Oracle Index Editor for Materialized ViewsNext Topic: Oracle Table Index Editor - Constraint State Tab


Oracle Table Index Editor

A primary key (PK) and a foreign key (FK) index are automatically created for each table in your model, based on the primary key and foreign key columns. If you designate columns as an alternate key group (AK) or inversion entry group (IE), the equivalent unique (AK) and non-unique (IE) indexes are also generated.

Use the Oracle Table Index Editor to create alternate key (unique) and inversion entry (non-unique) indexes for tables in your model. After you create an index, you can use the Oracle Table Index Editor to modify its properties, such as the index name, column members, physical properties, and user-defined properties.

Use the Generate as Constraint option so that Forward Engineering generates a constraint based on the information in the selected index. The types of constraints created from indexes are:

Unique Constraint

Prohibits multiple rows from having the same value in the same column or a combination of columns but allows some values to be NULL.

Primary Key Constraint

Combines a NOT NULL constraint and a unique constraint in a single declaration. That is, it prohibits multiple rows from having the same value in the same column or a combination of columns, and prohibits NULL values.

Foreign Key Constraint

Requires the values in one table to match the values in another table.

Use the following options and tabs in the Oracle Table Index Editor to define table index properties. You open this editor by right-clicking the table on the diagram that contains the index you want to define and selecting Index Properties.

Table

Displays the table to which the index belongs. You can select a different table using the drop-down control.

property editor PREVIOUS icon Previous

Positions the editor on the previous index in the Navigation Grid.

property editor NEXT icon Next

Positions the editor on the next index in the Navigation Grid.

property editor SORT icon Sort

Sorts the indexes by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the index list is currently sorted:

property editor SORT icon

Specifies that the list is sorted in alphabetic order.

Property editor Reverse Alpha Sort Button

Specifies that the list is sorted in reverse alphabetic order.

New icon in property editors to create a new object New

Creates a new index that becomes the current object in the editor.

property editor DELETE button Delete

Deletes the selected index.

property editor DB SYNC button DB Sync

Opens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.

property editor HELP button Help

Opens online help for the editor.

enter filter text box in a property editor to filter object list

Lets you filter a very large list of indexes in the Navigation Grid to quickly locate the index for which you need to view or define properties.

Show FK Indexes

Lets you specify whether to display FK indexes in the Navigation Grid.

Name

Specifies the name of the index. You can change the name of the index in this field.

Owner

Lets you assign a database Owner to the index.

Type

Displays the index type for the index.

Is Unique

Specifies whether to allow unique values in the index. Clear this check box to allow non-unique values.

Physical Only

Specifies whether to have the index appear in the physical model only. If you want the index to appear in the logical model as a key group, clear the check box.

Generate

Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

Generate As Constraint

Generates the index as a constraint. This option is disabled for non-unique alternate key indexes. Select this check box so that Forward Engineering generates a constraint based on the information in the selected index. The implications of selecting this option is that either ALTER TABLE ADD CONSTRAINT commands would be generated, or that CONSTRAINT clauses would be added to the CREATE TABLE, depending on the Forward Engineering option you select for Referential Integrity.

Members

Lets you specify index members.

Constraint State

Lets you assign constraint state properties.

Physical

Lets you assign physical property options.

Partitions

Lets you select partition type and partition type options.

Where Used

Lets you view where the object is used in the model.

Comment

Lets you enter any comments that you want to associate with the object.

UDP

Lets you enter user-defined property values for the object.

Notes

Lets you view or edit user notes.