Re: Materialized Views 9i vs 10g

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 19 Aug 2010 10:54:17 -0500
Message-ID: <AANLkTimDpqeM_Ei35vKsUZqUY0eb0xTj0EbTMd+iyF_i_at_mail.gmail.com>



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:

> 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.'

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 19 2010 - 10:54:17 CDT

Original text of this message