De script. ion
Performs a full table scan directly against a materialized view
ExampleThis 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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20945761/viewspace-558018/