What are the options available to refresh snapshots ?
Answers were Sorted based on User's Feedback
Answer / guest
COMPLETE - Tables are completly 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 the changes to the snapshot tables.
FORCE - Default value. If possible it performs a FAST
refresh; Otherwise it will perform a complete refresh.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nishi
COMPLETE - Tables are completly 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 the changes to the snapshot tables.
FORCE - Default value. If possible it performs a FAST refresh; Otherwise it will perform a complete refresh.
Is This Answer Correct ? | 0 Yes | 0 No |
What is Statement Auditing ?
what is snapshot log ?
What are the use of Roles ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What are the responsibilities of a Database Administrator ?
What are the benefits of distributed options in databases ?
What is a profile ?
What is the use of ANALYZE command ?
What dynamic data replication ?
What are the different Levels of Auditing ?
what is the step for rmanbackup?
what is meant by physical order and logical order in clustered index and non clustered index.