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...
Printable View
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...
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 ......................)