Materialized View

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

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

Creating a Materialized View

  1. On the Devart - Standard toolbar, click New Database Object.
  2. Select the Materialized View type in the dialog.
  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, see Defining Table Structure and Partitioned Tables.
  9. Save the document.

Note

Materialized views can be index-organized and clustered. To create index-organized or clustered materialized view select corresponding option on 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.