Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the options available to refresh snapshots ?

April 26, 2017Options Refresh snapshots

0

Posted

What are the options available to refresh snapshots ?

2 Answers

0

Posted

– 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.

0

Posted

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