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.

No comments: