ITPub博客

首页 > Linux操作系统 > Linux操作系统 > mat_view access full

mat_view access full

原创 Linux操作系统 作者:arthurshen_bleum 时间:2009-02-27 09:36:26 0 删除 编辑
De script. ion

Performs a full table scan directly against a materialized view

Example

This example was developed using Oracle 10.2.0.1 on Linux

This example requires the following object definitions

CREATE TABLE t1 (c1 NUMBER, c2 NUMBER); CREATE MATERIALIZED VIEW mv1 BUILD IMMEDIATE ENABLE QUERY REWRITE AS SELECT c1,SUM(c2) AS sum_c2 FROM t1 GROUP BY c1;

The statement

SELECT c1,sum_c2 FROM mv1;

generates the following execution plan

0 SELECT STATEMENT ptimizer=CHOOSE 1 0 MAT_VIEW ACCESS (FULL) OF 'MV1'

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20945761/viewspace-558018/,如需转载,请注明出处,否则将追究法律责任。

上一篇: a sql tuning
下一篇: high water mark
请登录后发表评论 登录
全部评论

注册时间:2009-02-26

  • 博文量
    36
  • 访问量
    26314