MV fast refresh

[Roshan]

Hi Erman,

can you please advise how I can modify query below to use fast refresh?

DDLBIGL.txt

Thanks,

Roshan

[ErmanArslansOracleBlog]

Please read ->  https://docs.oracle.com/database/121/DWHSG/basicmv.htm

Read the requirements and instructions given in the related subtitles such as ;

About Materialized Views with Aggregates
About Materialized Views Containing Only Joins
About Nested Materialized Views