Neoview Database Administrator's Guide (R2.3)

6. DB Admin prompts you to confirm that you want to create this materialized view. When
you click Yes, it attempts to create the view and either displays an error or indicates it was
successful and displays the new view.
DB Admin automatically creates a materialized view group that contains this materialized
view. For information on creating, changing, and dropping materialized view groups, see
“Materialized View Groups” (page 77).
For additional information, see DB Admin online help.
Displaying Materialized Views and Their Properties
1. Start DB Admin and log on using any user ID.
2. Click the Database tab, then navigate to the schema and click the materialized view name
in the right pane, or open the Materialized Views folder. DB Admin displays the materialized
views in this schema. Click the materialized view name in the lists in either pane. DB Admin
displays the materialized view’s information in the right pane:
Use the arrows on the right to view information under the Attributes, DDL, Space, and
Privileges tabs. Under the DDL tab, the DDL Tool button displays DDL information.
Materialized Views 75