DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Diff View and Snapshot

  1. #1
    Join Date
    Apr 2003
    Location
    Hyderabad
    Posts
    40

    Diff View and Snapshot

    What is the difference between View and SnapShot.

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    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.
    Cheers!
    OraKid.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width