Materialized Views
•Currently, indexes provide fast path
access to specific data
•Materialized views work on the same
principle
•A
Materialized view is an instantiation of a SQL statement
- a view with data storage
•Materialized
views can be partitioned, indexed separately
•Used for
query rewrite to increase performance
•Rewrites
are transparent to applications
•Rewrites do not require any special
privileges
CREATE MATERIALIZED VIEW
sf_sales
AS SELECT * FROM sales
AS SELECT * FROM sales
WHERE city_name = ’SAN FRANCISCO’
SF_Sales
SELECT prod_code FROM sales
WHERE city_name = ’SAN FRANCISCO’
SELECT prod_code FROM sf_sales
Sales
CREATE
