10gR1 Materialized View - RowNum and Index

I have a few doubts on creating Materialized Views (MV). Please clarify them [ Database is : Oracle 10gR1 (Datawarehouse) ] :

1. Can we create MV with rownum as one of the column ? for example : create materialized view mv1 as select a.col1, b.col2, rownum from a, b where a.col1 = b.col2 group by ...
2. What will be the performance impact, if we create MV with rownum ?
3. What will be the performance impact, if we create MV with rownum and Index created on :
4. all the columns, including rownum ?
5. all the columns, without rownum ?

Thanks.

With Regards,
Raja. Received on Thu Dec 17 2009 - 01:17:43 CST