Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Materialized View Editor › Oracle Materialized View Editor - Other Options Tab

Oracle Materialized View Editor - Other Options Tab

Use the Other Options tab to select options such as cache type, parallel type, build type, using index, and query rewrite state. The following describes the options available for this tab:

On Prebuilt Table

Select one of the following options:

WITH REDUCED PRECISION

WITHOUT REDUCED PRECISION

Cache Type

Select one of the following options:

CACHE

NOCACHE

Using Index

Establish the values of parameters for the default index Oracle uses to maintain the materialized view's data. Select one of the following options:

USING NO INDEX

This option suppresses the creation of the default index.

USING INDEX

This option uses the default index to make an incremental (FAST) refresh of a materialized view faster. When you select this option, select an index from the drop-down list. Click the button to open the Oracle Index Editor for Tables editor. Click the Storage Properties button to open the Oracle Storage Properties Dialog.

Parallel Type

Select one of the following options:

NOPARALLEL

PARALLEL

If you select this option, enter a value in the VALUE textbox.

Build Type

Select one of the following options:

IMMEDIATE

This option indicates that the materialized view is populated immediately.

DEFERRED

Indicates that the materialized view will be populated by the next refresh operation.

Updatable Query

Select this option to allow an update of a materialized view.

Query Rewrite State

Specify whether the materialized view is eligible to be used for query rewrite. Select one of the following options:

ENABLE

Enable the materialized view for a query rewrite.

DISABLE

Indicates that the materialized view is not eligible for use by query rewrite.