･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ｡ｦ･ﾓ･蝪ｼ (materialized view)

ｼﾂﾂﾎ､�ｻ�､ﾃ､ｿ･ﾓ･蝪ｼ､�ｺ�ﾀｮ､ｹ､�､ｳ､ﾈ､ｬ､ﾇ､ｭ､�｡｣Oracle8 ､ﾇ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ･�･�･ｯ､ﾈｸﾆ､ﾐ､�､ﾆ､､､ｿ､筅ﾎ｡｣

create materialized view ･ﾓ･蝪ｼﾌｾ
    refresh ･�･ﾕ･�･ﾃ･ｷ･螂ｿ･､･ﾗ ･�･ﾕ･�･ﾃ･ｷ･螂筍ｼ･ﾉ as sqlﾊｸ

･�･ﾕ･�･ﾃ･ｷ･螂ｿ･､･ﾗ

complete	ｴｰﾁｴ･�･ﾕ･�･ﾃ･ｷ･蝪｣･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ｡ｦ･ﾓ･蝪ｼﾆ筅ﾎﾁｴ･ﾇ｡ｼ･ｿ､�ｺ�ｽ�ｸ蝪｢ｿｷｵｬﾁﾞﾆ�､ｹ､�｡｣
fast	ｸｵﾉｽ､ﾋｹｹｿｷ､ｬﾈｯﾀｸ､ｷ､ｿｾ�ｹ遑｢ｹｹｿｷﾊｬ･ﾇ｡ｼ･ｿ､ﾎ､ﾟ･�･ﾕ･�･ﾃ･ｷ･螟ｹ､�｡｣
force	｣ｱ｡｢fast｡｡ﾉﾔｲﾄﾇｽ､ﾇ､｢､ﾃ､ｿｾ�ｹ遑｢complete

･�･ﾕ･�･ﾃ･ｷ･螂筍ｼ･ﾉ

on commit	ｼｫﾆｰｹｹｿｷ
on demand	ｼ�ﾆｰｹｹｿｷ

on demand ､ﾎｾ�ｹ遉ﾎｼ�ﾆｰｹｹｿｷﾊ�ﾋ｡

DBMS_MVIEW.REFRESH('･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ･ﾓ･蝪ｼﾌｾ')	ｻﾘﾄ�･ﾓ･蝪ｼ､ﾎ･�･ﾕ･�･ﾃ･ｷ･�
DBMS_MVIEW.REFRESH_DEPENDENT('･ﾇ･｣･ﾆ･｣｡ｼ･�ﾉｽﾌｾ')	ｴﾘﾏ｢ﾉｽ､ﾎ･�･ﾕ･�･ﾃ･ｷ･�
DBMS_MVIEW.REFRESH_ALL_MVIEWS()	ﾁｴ､ﾆ､ﾎ･ﾓ･蝪ｼ､�･�･ﾕ･�･ﾃ･ｷ･�

･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ･ﾓ･蝪ｼ､ﾎｺ�ｽ�

drop materialized view ･ﾓ･蝪ｼﾌｾ

･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ･ﾓ･蝪ｼ､ﾎ･ｨ･鬘ｼｻｲｾﾈ

exec dbms_mview.explain_mview('･ﾞ･ﾆ･�･｢･鬣､･ｺ･ﾉ･ﾓ･蝪ｼﾌｾ');