Re: Materialized View - Performance
Date: Thu, 6 Nov 2008 13:25:32 -0800 (PST)
On Nov 6, 1:25†am, raja <dextersu..._at_gmail.com> wrote:
> I am using Oracle 10g.
> Please answer my doubts regarding Materialized Views ( MV ) :
> 1. if we give the option 'enable query rewrite' option, while creating
> MV, will the optimizer do automatic query rewriting and optimize the
> MV ?
> 2. Can i use WITH Clause in a MV ?
> 3. I am looking for performance tuning of MV, any tips on that, Please
> † †Please Note : The problem here is that, I donít have privileges to
> access Oracle packages, So any manual ways/tips to tune the MVs.
> Please suggest.
> † †Also, any docs/URL related to performance tuning of MV.
> Thanks in Advance.
> With Regards,
I notice the performance tuning section of EM has a rewrite link to click on when you are looking at the plan, but I haven't tried it.
-- @home.com is bogus. telnet enabled by default: http://www.brightblue.schlage.com/pdf/bbmanual_hardware.pdfReceived on Thu Nov 06 2008 - 15:25:32 CST