SQL & PL/SQL

Hi All,

Can I create index on materialized views independently? I mean, after I created a materialized view can I create an index like a heap table as below?

CREATE MATERIALIZED VIEW KIOS.MV_TEST

NOCACHE

LOGGING

NOCOMPRESS

NOPARALLEL

BUILD IMMEDIATE

REFRESH COMPLETE ON DEMAND

WITH PRIMARY KEY

AS

SELECT * FROM V_TEST;

CREATE INDEX IND_TEST ON MV_TEST ON (COL1);

Also, I am wondering, when we create a MV. How does WITH PRIMARY KEY clause interacts with INDEXES?

Thanks