Creating a Materialized View

To create a materialized view:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. Click Create.

3. From the list of object types, select Materialized View.

4. Define the materialized view:

   1. Materialized View Name - Enter a name.

   2. Query - Specify a query to define the view.

      To access Query Builder or SQL Command Processor, click the appropriate link at the bottom of the page. The selected tool appears in a pop-up window. Once you generate the appropriate SQL, click Return to automatically close the popup window and return to the wizard with the SQL.

   3. Click Next.

      A confirmation page appears. To view the SQL used to create the materialized view, click SQL.

5. Click Create.