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

Thread: Materialized View and View

  1. 03-13-2003, 01:29 AM #1
    mepancha
    mepancha is offline Junior Member
    Join Date
    Jan 2003
    Posts
    9

    Materialized View and View

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

    Thanks
    Reply With Quote Reply With Quote
  2. 03-13-2003, 03:05 AM #2
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 03-13-2003, 03:11 AM #3
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width