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

Thread: Materialized View

  1. 04-07-2008, 03:17 PM #1
    crey
    crey is offline Junior Member
    Join Date
    Mar 2008
    Posts
    4

    Materialized View

    Hello, I am learning some about materialized view and my question is:
    Could the materialized views cause some aditional consequences or problems in the normal database performance?

    version: oracle 8.1.7

    thanks!!!!
    Last edited by crey; 04-07-2008 at 03:24 PM.
    Reply With Quote Reply With Quote
  2. 04-08-2008, 04:51 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    It all depends on what you do with your materialized view, just as an example a simple MVIEW that gets recreated once a week when no users are hitting the database would have less impact that a complex MVIEW that gets refreshed once an hour 24x7
    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.
    Reply With Quote Reply With Quote
  3. 04-08-2008, 08:40 AM #3
    crey
    crey is offline Junior Member
    Join Date
    Mar 2008
    Posts
    4

    Materialized View - Colateral Effect

    Thanks for your answer. But I refer about the disadvantages or bad consecuences when we use MVIEW in the database's performance. The effect in the database. I know that more complex more impact, but Are there "Colateral Effects" to I have take account?

    Thanks a lot!!!!

    P/D: Sorry for my english. I am Argentinian.
    Last edited by crey; 04-08-2008 at 08:42 AM.
    Reply With Quote Reply With Quote
  4. 04-08-2008, 11:09 AM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    well... who would know Argentinian was so close a language to English

    Would you mind in defining what would be a "collateral effect"? please note that what I've described shows two very different impacts on database performance depending on your particular MVIEW.

    Also, take into consideration you shouldn't resort to MVIEWs because they have a cool name, you resort to them when you really need them.
    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.
    Reply With Quote Reply With Quote
  5. 04-09-2008, 07:07 AM #5
    gopu_g's Avatar
    gopu_g
    gopu_g is offline Senior Member
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    go through the links about materialized views

    http://www.akadia.com/services/ora_m...zed_views.html
    http://www.oreillynet.com/pub/a/orei...cle8_0600.html
    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