> For the complete documentation index, see [llms.txt](https://docs.tibero.com/tiberostudio.en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/tiberostudio.en/about/schema-tree-browser/materialized-view/create-materialized-view.md).

# Create Materialized View

Materialized View object can be created through the GUI operation as executing the following process.

**Materialized View Folder > Context Menu > Create Materialized View** 

The details can be set in each tab: [#common](#common "mention"), [#query](#query "mention"), [#materialized-view-info](#materialized-view-info "mention"), [#storage](#storage "mention"), [#index](#index "mention"), [#partition](#partition "mention"), [#comment](#comment "mention") 

<figure><img src="/files/gW7dt3Z1kAoTu1tF8d2h" alt=""><figcaption><p>Create Materialized View screen</p></figcaption></figure>

SQL applied to the settings is shown in the SQL area at the bottom.

## Common

Sets the Schema, Name of the Materialized View to be created.

<figure><img src="/files/a7MxboMOObEaRaHikVBc" alt=""><figcaption><p>Create Materialized View - Common tab screen</p></figcaption></figure>

<table><thead><tr><th width="117">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Schema</strong></td><td><p>Select the Schema to create the Materialized View. </p><p>Default: Current Connection Created Schema </p></td></tr><tr><td><strong>Name</strong></td><td>Enter the name of the Materialized View to be created.</td></tr></tbody></table>

## Query

Create a query to create a Materialized View.

The detailed operation is the same as **Create View > Query tab**. [Create View](/tiberostudio.en/about/schema-tree-browser/view/create-view.md#query)

<figure><img src="/files/9tm2SwuaFkvdcMQdM7Fb" alt=""><figcaption><p>Create Materialized View - Query tab screen</p></figcaption></figure>

## Materialized View Info

Set the information of the Materialized View to be created.

<figure><img src="/files/B7h8JrPBpgFpiJDHyR7n" alt=""><figcaption><p>Create Materialized View - Materialized View Info tab screen</p></figcaption></figure>

* Refresh Setting

  <table><thead><tr><th width="164">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Refresh Mode</strong></td><td><p>Select the Refresh Mode.</p><ul><li>On Demand (default): Refresh is performed only when the user calls the REFRESH prerequisite of the DBMS_MVIEW package.</li><li>On Commit: Refresh is performed every time a commit is made to the master table.</li><li>Time: Select the date type expression at which the first refresh occurs. If selected, the bottom Start with, Next fields are enabled.</li><li>Never Refresh: Never perform an automatic refresh. The bottom fields are all disabled. </li></ul></td></tr><tr><td><strong>Start With</strong> </td><td><p>Set the date from which the refresh will begin. </p><p>Enabled when Time is selected in Refresh Mode.</p></td></tr><tr><td><strong>Next</strong></td><td><p>Set the interval for Refresh. </p><p>Enabled when Time is selected in Refresh Mode. </p></td></tr><tr><td><strong>Refresh Method</strong></td><td><p>Select the refresh method.</p><ul><li>Force: Performs a quick refresh if a quick refresh is available, otherwise performs a full refresh.</li><li>Fast: Performs a quick refresh.</li><li>Complete (default): Performs a complete refresh by re-executing the query that defines the Materialized View.</li></ul></td></tr><tr><td><strong>With</strong></td><td>Selects the identifier to use for synchronization on refresh.</td></tr></tbody></table>

* Build Setting

  <table><thead><tr><th width="169">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Build Mode</strong></td><td><p>Select the Build Mode.</p><ul><li>Immediate (Default): Insert data as soon as the Materialized View is created.</li><li>Deferred: Insert data when refreshing for the first time.</li><li>Prebuilt Table -Default (Without Reduced Precision): The precision of the columns in the table should match the result of the query that defined the Materialized View. When selected, the fields on the Storage tab are not configurable.</li><li>Prebuilt Table (With Reduced Precision): Allows the precision of the columns in the table to differ from the results of the query that defined the Materialized View. When selected, the fields on the Storage tab are not configurable. </li></ul></td></tr><tr><td><strong>Query Rewrite Enable</strong></td><td>Materialized View is used for rewriting queries.</td></tr></tbody></table>

## Storage

Set the physical properties of the storage space and the Tablespace and Segment properties of the Materialized View to be created.

<figure><img src="/files/ojsCS6Vri5wI69WBBbKB" alt=""><figcaption><p>Create Materialized View - Storage tab screen</p></figcaption></figure>

For detailed fields, see the **Create Table > Storage** tab.  [Create Table](/tiberostudio.en/about/schema-tree-browser/table/create-table.md#storage)

{% hint style="info" %}
**Note**

If the build mode is selected as Prebuilt Table - Default (Without Reduced Precision) or Prebuilt Table (With Reduced Precision) in the Materialized Info tab, all fields in that tab cannot be set.
{% endhint %}

## Index

Sets the Index of the Materialized View to be created.

<figure><img src="/files/89grmXvuLYg9sTO5HIJz" alt=""><figcaption><p>Create Materialized View - Index tab screen</p></figcaption></figure>

The detailed fields and work are the same as [Create Table](/tiberostudio.en/about/schema-tree-browser/table/create-table.md#indexes).

## Partition

Sets the Partition and SubPartition of the Materialized View to be created.

<figure><img src="/files/reRq5FCF8NShqQirP81G" alt=""><figcaption><p>Create Materialized View - Partition tab screen</p></figcaption></figure>

The detailed work is the same as the **Create Table > Partition** tab. [Create Table](/tiberostudio.en/about/schema-tree-browser/table/create-table.md#partition)

## Comment

Create a Comment for the Materialized View to be created.

<figure><img src="/files/klUUSPZqgqh4jcVWcnzZ" alt=""><figcaption><p>Create Materialized View - Comment tab screen</p></figcaption></figure>

Click **\[Reset button]** to initialize the creation contents.

After setting the details of each tab, click **\[Ok button]** to create a Materialized View object with the settings

###


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.tibero.com/tiberostudio.en/about/schema-tree-browser/materialized-view/create-materialized-view.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.