Re: Materialized Views 9i vs 10g

From: Andrew Kerber <>
Date: Thu, 19 Aug 2010 10:54:17 -0500
Message-ID: <>

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 <>wrote:

> Hi,
> 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.
> Thanks,
> Chuck

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Thu Aug 19 2010 - 10:54:17 CDT

Original text of this message