RE: Materialized View+complete refresh
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 May 2009 15:17:45 -0400
Just because you have tuned the query does not mean that more gains
cannot be had by re-tuning it again.
If the query is as good as it can get on its own then you have adding
parallelism but to get the best gains from running parallel you might
actually have to un-tune the query. That is, some of the changes you
made to get the query to run in 20 minutes may actually hinder the CBO
with PQO so you may need to test several versions of the query.
Otherwise you need to try to tune the refresh process as Jared
suggested.
But where is the explain plan for this query? Everyone is working blind
without it.
-- Mark D Powell --
Phone (313) 592-5148
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mohammed Mehraj
hussain
Sent: Wednesday, May 20, 2009 10:29 PM
To: Jack van Zanen
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Materialized View+complete refresh
we Have already tuned the query and then we have reduced it to this
time(20 min)...
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
