What Are The Options Available To Refresh Snapshots ?

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.

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