Materialized Views 9i vs 10g
- From: Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2010 08:47:37 -0700
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
Other related posts:
