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
- On the Standard toolbar, click New Database Object.
- Select the Materialized View type in the dialog box.
- Input a materialized view name.
- Click Create. If specified name is unique, the materialized view editor appears.
- Type a query that will represent the materialized view.
- Optionally, you can alter the name or change owner in which the new materialized view will be created.
- Optionally, switch to the Options tab and set materialized view creation and refresh parameters.
- 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.
- Save the document.
Note
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
- In Database Explorer, expand the Materialize View folder.
- 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.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?