Performs a full table sample scan directly against a materialized view using range of ROWIDs
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 c1,sum_c2 FROM mv1 SAMPLE (10) WHERE ROWID > ( SELECT MIN (ROWID) FROM mv1 );
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 MAT_VIEW ACCESS (SAMPLE BY ROWID RANGE) OF 'MV1' 2 1 SORT (AGGREGATE) 3 2 MAT_VIEW ACCESS (FULL) OF 'MV1'