Materialized Views and Dimensions

转载于 2017-11-12 18:16:00 发布 · 64 阅读

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/526613

本文介绍如何使用Oracle数据库中materialized view的特性来提高查询效率。包括为用户Scott授予创建materialized view及允许查询重写的权限，以及创建名为STAFF_MV_SIMPLE的materialized view的具体步骤。

Materialized Views and Refresh Types This practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table. 1) Grant the necessary privileges for user Scott to create materialized views and allow query rewrite on the materialized views owned by schema Scott.

As user SYSTEM, execute the following command:> grant CREATE MATERIALIZED VIEW, QUERY REWRITE to scott;

2) As user Scott, create a materialized view name STAFF_MV_SIMPLE from the Employees table. You want the materialized view to only store dat

本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1276701