
In the right pane, these tabs appear:
• Columns tab (user only)
• Attributes tab
• DDL tab
• Partitions tab
Columns Tab
To display the materialized view index columns:
1. Select a Schema in the navigation tree.
2. Open the Materialized Views folder, select and open a materialized view.
3. Open the Indexes folder and select a materialized view index in the tree.
4. Click the Columns tab in the right pane.
In the right pane these attributes are displayed:
• Column Name: Name of the column (string).
• Sort Order: Specifies the order as “Ascending” or “Descending.”
• Added By: Indicates if column was added by the “System” or “User.”
Attributes Tab
To display the materialized view attributes:
1. Select a Schema in the navigation tree.
2. Open the Materialized Views folder, select and open a materialized view.
3. Open the Indexes folder and select a materialized view index in the tree.
4. Click the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
Display Materialized View Indexes and Their Properties 81
Commentaires sur ces manuels