RE: Materialized Views 9i vs 10g
Date: Thu, 19 Aug 2010 12:13:37 -0700
So sorry..these are all using FAST refresh…
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Thursday, August 19, 2010 11:31 AM
To: Chuck Boddy
Subject: Re: Materialized Views 9i vs 10g
Didn't the default for MV change with 10g from doing a truncate to doing a delete?
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
>>> Jared Still <jkstill_at_gmail.com> 8/19/10 1:58 PM >>>
On Thu, Aug 19, 2010 at 8:47 AM, Chuck Boddy <Chuck.Boddy_at_gettyimages.com<mailto: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.
What does performance mean?
Too long to apply changes?
Too long to select?Received on Thu Aug 19 2010 - 14:13:37 CDT