Re: 10gR1 Materialized View - RowNum and Index
Date: Mon, 21 Dec 2009 23:16:16 -0800 (PST)
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
Raja. Received on Tue Dec 22 2009 - 01:16:16 CST