Recently, in enterprise's Oracle database, I have seen some materialized views that filter directly columns of table without adding aggregate fields and without calling custom functions.
create view VW_IMP_INVENTORY as SELECT <some-columns> FROM <other-schema>.TB_INVENTORY; create materialized view MV_IMP_INVENTORY as SELECT * from VW_IMP_INVENTORY;
In this situation, what are the advantages of using a
MATERIALIZED VIEW instead of using directly the
VIEW used in
MATERIALIZED VIEW ?