Materialized View and View
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Materialized View and View

  1. #1
    Join Date
    Jan 2003
    Posts
    9

    Materialized View and View

    Hi,
    I need to know the acutal difference between Views and Materialized view.

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    i try to

    * Views are stored SQL-Queries, but no view-data is stored.
    * Mviews are stored SQL-Quries to local or far objects, the view-data is stored locally and refreshed by specific interval. Mviews are not new, they derived from snapshots.
    Oracle uses Mviews for more, for example with query-rewrite to speed up aggragated data-access.

    Orca

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    views are stored SQL

    mviews are physical tables, like snapshots need to get refreshed at certain time, full or incremental, they are also used by the optimizer to accomplish query rewrites

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