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:
Prohibits multiple rows from having the same value in the same column or a combination of columns but allows some values to be NULL.
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.
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.
Displays the table to which the index belongs. You can select a different table using the drop-down control.
PreviousPositions the editor on the previous index in the Navigation Grid.
NextPositions the editor on the next index in the Navigation Grid.
SortSorts 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:
Specifies that the list is sorted in alphabetic order.
Specifies that the list is sorted in reverse alphabetic order.
NewCreates a new index that becomes the current object in the editor.
DeleteDeletes the selected index.
DB SyncOpens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.
HelpOpens online help for the editor.
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.
Lets you specify whether to display FK indexes in the Navigation Grid.
Specifies the name of the index. You can change the name of the index in this field.
Lets you assign a database Owner to the index.
Displays the index type for the index.
Specifies whether to allow unique values in the index. Clear this check box to allow non-unique values.
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.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
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.
Lets you specify index members.
Lets you assign constraint state properties.
Lets you assign physical property options.
Lets you select partition type and partition type options.
Lets you view where the index is used in the model.
Lets you enter any comments that you want to associate with the index.
Lets you enter user-defined property values for an index.
View index history information and view or edit user notes.
|
Copyright © 2013 CA.
All rights reserved.
|
|