Re: 10gR1 Materialized View - RowNum and Index

From: raja <dextersunil_at_gmail.com>
Date: Mon, 21 Dec 2009 23:16:16 -0800 (PST)
Message-ID: <b1c4f073-b2d9-4a37-8886-0e5cc819532f_at_f20g2000prn.googlegroups.com>



Hi,

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

Thanks.

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

Original text of this message