Oracle 实体化视图-本地索引

SQL> create table T as select * from dba_Objects;

Table created.

SQL> create table MV ( owner varchar2(30), tot int )
  2  partition by list ( owner )
  3   ( partition p1 values ('SYS'),
  4     partition p2 values (default )
  5   );

Table created.

SQL>
SQL> insert into MV
  2  select owner, count(*)
  3  from t
  4  group by owner;

36 rows created.

SQL> create materialized view MV
  2  on prebuilt table with reduced precision
  3  refresh complete
  4  as
  5  select owner, count(*) tot
  6  from t
  7  group by owner;

Materialized view created.

SQL>
SQL> create index MV_IX on MV ( owner ) local;

Index created.

SQL>
SQL>