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

Thread: materialized views

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi Friends,
    Are the materialized views only useful to decrease the response time of a query where joins are involved?
    Dont they help in increasing the performance, even when query runs on a single table by reducing the I/O contention?
    Thanks
    manjunath

  2. #2
    Join Date
    Feb 2001
    Location
    Baltimore,MD USA
    Posts
    27

    Materialized view

    Materialized view r useful in data wearhousing.
    It's useful in queries with joins,aggregates functions.
    if single table queries with aggregate function then u can use mview for that. That is called single table mview. which can improve responce time of query and also reduce i/o contention on that table.
    kuckoo

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