Re: Materialized View - Performance

From: gazzag <gareth_at_jamms.org>
Date: Thu, 6 Nov 2008 03:20:16 -0800 (PST)
Message-ID: <21741e4c-5ba1-4d25-9a81-ea984dcd46a9@d10g2000pra.googlegroups.com>


On 6 Nov, 09:25, raja <dextersu..._at_gmail.com> wrote:
> Hi,
>
> 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
> suggest.
> † †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,
> Raja.

Regarding tuning: http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/advisor.htm#i1018993

HTH -g Received on Thu Nov 06 2008 - 05:20:16 CST

Original text of this message