如题,还请帮助,怎么查看物化视图建立的索引
语句怎么建立索引啊?
------解决思路----------------------
--CREATE TABLE
create table test(id number);
--CREATE MATERIALIZED VIEW
CREATE MATERIALIZED VIEW test_view
REFRESH FORCE
WITH ROWID
AS SELECT * FROM test;
--CREATE INDEX ON MATERIALIZED VIEW
CREATE INDEX indx_test
ON test_view (id);
--QUERY THE CREATED INDEX
select * FROM user_indexes t where t.index_name='INDX_TEST';