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

Thread: Materialized view

  1. #1
    Join Date
    Jul 2007
    Posts
    32

    Thumbs up Materialized view

    Hi,

    Can u give me small explanation about materialized view?
    plz.....

    TIA,

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    small explanation?
    OK
    It's like a view but, materialized.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    Materialized views designed to speed up queries by storing data from queries in a pre-joined, pre-summarized format. Unlike traditional view ,which is merely stored in the data dictionary as a select statement that is executed when the view is accessed.

    A materialized view stores the physical result of the view in its own segment, separate and distinct from the underlying table on which the view is based. The segment can be stored in its own tablespace and can be indexed and partitioned.

    Materialized views are intended primarily for use in data warehouse and decision support system where large volumes of data are accessed and summarized using queries.
    Last edited by liakat; 07-27-2007 at 01:57 PM.

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    It also should be refreshed and can be used for query rewrite but you'd probably need dimensions for that to work, and the parameter QUERY_REWRITE_ENABLED set to true.
    The refresh can be fast or complete but not always fast works, that's why FORCE can be used.
    So.... short description of MVIEWS is really something like shiny night

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