Performs lookups using a range of ROWIDs directly against a materialized view
This operation is implemented in the following versions
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;
SELECT sum_c2 FROM mv1 WHERE ROWID > ( SELECT MIN (ROWID) FROM mv1 );
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 MAT_VIEW ACCESS (BY ROWID RANGE) OF 'MV1' 2 1 SORT (AGGREGATE) 3 2 MAT_VIEW ACCESS (FULL) OF 'MV1'