Showing posts with label to g. Show all posts
Showing posts with label to g. Show all posts

Sunday, October 19, 2008

Difference between View and a Snapshot

A View is a stored select statement, so the data is obtained from the base table on the fly, every time the view is queried.

A Snapshot is a physical copy of data from one or more tables. This data can be refreshed on demand or at specified intervals to get the changes made on the base tables.