Re: 10gR1 Materialized View - RowNum and Index

From: raja <>
Date: Mon, 21 Dec 2009 23:16:16 -0800 (PST)
Message-ID: <>


Thanks for all ur responses.
Sorry, but I think, still i am not convinced with the answers. The question that i asked is related to PERFORMANCE impact.

Will there be an impact in performance ( either increase or decrease ) when we create a MV with ROWNUM as one of the columns : 1) having ROWNUM as one of the INDEXED columns, 2) having ROWNUM not indexed


With Regards,
Raja. Received on Tue Dec 22 2009 - 01:16:16 CST

Original text of this message