oracle read rewrite 功能概述 - 数据库编程

当前位置：

TOP

oracle read rewrite 功能概述

2014-11-24 08:06:47 来源: 作者: 【大中小】浏览:2次

alter session set query_rewrite_enabled = true;

alter session set query_rewrite_integrity = enforced;

create

create materialized view my_all_objects_aggs

build immediate

refresh on commit

enable query rewrite

as

select owner,count(*) from my_all_objects group by owner

/

analyze table my_all_objects_aggs compute statistics;

set autot on

set timing on

select owner,count(*) from my_all_objects group by owner


【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：一套Oracle SQL练习题及答案	下一篇：oracle rowid详解