|
The optimizer maintains a list of materialized views that can be used in the optimization process. A materialized view is not considered a candidate for use in optimization if its definition includes certain elements that the optimizer rejects, or if it is considered too stale for use. For information about what qualifies a materialized view as a candidate in the optimization process, see Improving performance with materialized views.
By default, materialized views are available for use by the optimizer. However, you can disable optimizer's use of a materialized view unless it is explicitly referenced in a query.
Connect to the database as the DBA.
Open the Views folder and right-click the materialized view.
Select Properties.
The Properties page for the materialized view displays.
On the General tab, place a checkmark next to Used in optimization, and then choose OK.
Connect to the database as the DBA.
Open the Views folder and right-click the materialized view.
Select Properties.
The Properties page for the materialized view displays.
On the General tab, remove the checkmark next to Used in optimization, and then choose OK.
Connect to the database as the DBA, or as owner of the materialized view.
Execute an ALTER MATERIALIZED VIEW statement with the ENABLE USE IN OPTIMIZATION clause.
Connect to the database as the DBA, or as owner of the materialized view.
Execute an ALTER MATERIALIZED VIEW statement with the DISABLE USE IN OPTIMIZATION clause.
The following statement enables the EmployeeConfidential view for use in optimization:
ALTER MATERIALIZED VIEW EmployeeConfidential ENABLE USE IN OPTIMIZATION;
The following statement disables the EmployeeConfidential view from use in optimization:
ALTER MATERIALIZED VIEW EmployeeConfidential DISABLE USE IN OPTIMIZATION;