Use the following options and tabs in the Oracle Materialized View Index Editor to modify properties for an index in a materialized view. You open this editor by right-clicking the materialized view on the diagram that contains the index you want to manage, and select Index Properties.
Displays the materialized view to which the index belongs. You can select a different materialized view using the drop-down control.
Positions the editor on the previous index in the Navigation Grid.
Positions the editor on the next index in the Navigation Grid.
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:
Specifies that the list is sorted in alphabetic order.
Specifies that the list is sorted in reverse alphabetic order.
Creates a new index that becomes the current object in the editor.
Deletes the selected index.
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.
Opens 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.
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.
Lets you specify index members.
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.
Oracle materialized view indexes are supported in the following features:
Copyright © 2013 CA.
All rights reserved.
|
|