What is the difference between View and SnapShot.
Printable View
What is the difference between View and SnapShot.
View - The data is fetched from the base tables when the view is queried.
Snapshot - The snapshot physically stores data (like a table) hence data is not fetched from the base tables. The data is fetched from the base tables only when the snapshot is refreshed, not at the time of querying the snapshot.