Re: Materialized View - Performance

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 03 Dec 2008 18:04:46 +0100
Message-ID: <4936bc30$0$200$e4fe514c@news.xs4all.nl>


raja schreef:
> 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.

What is causing performance problems: creating the MV or querying it?

Shakespeare Received on Wed Dec 03 2008 - 11:04:46 CST

Original text of this message