You can alter the materialized view??™s storage parameters via the alter materialized
view command, as in this example:
alter materialized view STORE_DEPT_SAL_MV pctfree 5;
The two most frequently used operations against a materialized view are query execution
and fast refresh. Each of these actions requires different resources and has different performance
requirements. You may index the base table of the materialized view; for example, adding an
index to improve query performance. If you have a materialized view that only uses join conditions
and fast refresh, indexes on the primary key columns may improve the fast refresh operations. If
your materialized view uses both joins and aggregates and is fast refreshable, as shown in the last
example, an index is automatically created for the materialized view unless you specify using no
index in the create materialized view command.
To drop a materialized view, use the drop materialized view command:
drop materialized view STORE_DEPT_SAL_MV;
616 Oracle Database 11g DBA Handbook
Using DBMS_MVIEW and DBMS_ADVISOR
There are multiple supplied packages you can use to manage and evaluate your materialized
views, including DBMS_MVIEW, DBMS_ADVISOR, and DBMS_DIMENSION.
The DBMS_MVIEW package subprograms are shown in Table 17-1; this package is used to
perform management tasks such as evaluating, registering, or refreshing a materialized view.
Subprogram Description
BEGIN_TABLE_
REORGANIZATION
A process to preserve the data needed for a materialized
view refresh is performed, used prior to reorganizing the
master table.
Pages:
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906