1.

What Are The Options Available To Refresh Snapshots?

Answer»

COMPLETE – TABLES are COMPLETELY regenerated using the snapshots query and the master tables every time the snapshot referenced.
FAST – If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
FORCE – Default value. If possible it performs a FAST REFRESH; Otherwise it will perform a complete refresh.

COMPLETE – Tables are completely regenerated using the snapshots query and the master tables every time the snapshot referenced.
FAST – If simple snapshot used then a snapshot log can be used to send the changes to the snapshot tables.
FORCE – Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.


Discussion

No Comment Found

Related InterviewSolutions