Materialized Views 9i vs 10g
From: Chuck Boddy <Chuck.Boddy_at_gettyimages.com>
Date: Thu, 19 Aug 2010 08:47:37 -0700
Message-ID: <8DC04761D4E2734EA65935501DB2C8E301311D1F664A_at_SEAPXCH7MBX01.amer.gettywan.com>
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.
Date: Thu, 19 Aug 2010 08:47:37 -0700
Message-ID: <8DC04761D4E2734EA65935501DB2C8E301311D1F664A_at_SEAPXCH7MBX01.amer.gettywan.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 19 2010 - 10:47:37 CDT