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

Thread: MATERIALIZED VIEW

  1. #1
    Join Date
    Jun 2001
    Posts
    316

    Hi,
    Can any1 pls tell me the xact funda of this MATERIALIZED VIEWS.
    How do i pupoulate this not by a single select query..but data 1 by 1 ..if at all its possible....
    thanx...

  2. #2
    Join Date
    Jan 2001
    Posts
    153
    Materialized views are used in data warehouses to increase the speed of queries on very large databases. Queries to large databases often involve joins between tables or aggregations such as SUM, or both. These operations are very expensive in terms of time and processing power..

    CREATE Materialized view......AS
    (SELECT ......................)
    Vijay.s

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