Re: Materialized Views 9i vs 10g
Date: Thu, 19 Aug 2010 10:54:17 -0500
Did you re-gather stats on the underlying tables when you went to 10g?
On Thu, Aug 19, 2010 at 10:47 AM, Chuck Boddy <Chuck.Boddy_at_gettyimages.com>wrote:
> I am taking Materialized Views that were initially built on a 9i database
> and rebuilding them on a 10g database – verbatim. I am noticing that the
> performance is noticeably degraded. Checked out the Explain Plan on 9i vs
> 10g for some the materialized views, and they would indicate that on 10g,
> the materialized views should at least perform the same OR performance
> should be approved. Any ideas would be appreciated.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 19 2010 - 10:54:17 CDT