数据库物化视图临时表0学习课件.pptVIP

Materialized Viewsand Temporary Tables Objectives After completing this lesson, you should be able to do the following: Identify the purpose and benefits of materialized views Create materialized views Enable query rewrites Create dimensions Identify the benefits of temporary tables Materialized Views A materialized view: Is an “instantiation” of a SQL statement Has its own data segment and offers: Space management options Use of its own indexes Is useful for: Expensive and complex joins Summary and aggregate data Why Materialized Views? Why Materialized Views? How Many Materialized Views? Qu