Materialized Views

Materialized view is a database object, that contains the results of a query.

Using dbForge Studio you can create, edit and delete materialized views.

Creating a Materialized View

  1. On the Standard toolbar, click New Database Object.
  2. Select the Materialized View type in the dialog box.
  3. Input a materialized view name.
  4. Click Create. If specified name is unique, the materialized view editor appears.
  5. Type a query that will represent the materialized view.
  6. Optionally, you can alter the name or change owner in which the new materialized view will be created.
  7. Optionally, switch to the Options tab and set materialized view creation and refresh parameters.
  8. You can set materialized view storage options, indexes, constraints and partitioning settings in the same way that you do for tables. For more information, read Defining Table Structure and Partitioned Tables.
  9. Save the document.


Materialized views can be index-organized and clustered. To create index-organized or clustered materialized view select corresponding option on the General tab. You can set additional parameters for clustered or index-organized materialized views just like setting these parameters for clustered or index-organized tables.

Editing a Materialized View

  1. In Database Explorer, expand the Materialize View folder.
  2. Select a required materialized view, and click Edit Materialized View on the shortcut menu.

To delete a materialized view, select a required materialized view, and click Delete on the shortcut menu.