
96 4.3 Types of Materialized Views
a little bit of a problem, perhaps taking an acceptable time to update but
an unacceptable amount of time and resources to create initially. In the
next example, the materialized view is only altered if the SALE fact table is
altered. It seems sensible, since dimensional data is static in nature, that it
is unlikely to be updated. Additionally, using the REFRESH FORCE
option will make the materialized view fast refresh for changes to the fact
table and not the dimensions—a perfectly sensible and perhaps more
attainable scenario. However, dimensional changes will cause a complete
refresh to occur, and that is a possibility ...