| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Weekly aggregates
I think I need to read more on the MVs. Right now I'm
very unclear how can they add something to a prebuild
table. I thought they could replace an aggregate.
Thanks for the advice, everyone (Paula, Beth, Dennis, Darrel, hope I didn't miss anyone). I might revive this thread when I get some more knoledge about MVs.
Gene
--- Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
wrote:
>
> One of the options for materialized views
> is to 'create MV on prebuilt table'
>
> If you want to use the table for direct queries,
> then you can - if you enable query rewrite then
> suitable queries against the base tables can
> be rewritten to take advantage of the MV.
>
> It's a technique I've advised clients to use
> when materialized views first appeared and
> they already had a big investment in code to
> create aggregate tables. Prebuilt tables
> are also my favourite option for MVs - you
> don't get the awful unpredictable that can
> appear with dynamic refreshes.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Now available One-day tutorials:
> Cost Based Optimisation
> Trouble-shooting and Tuning
> Indexing Strategies
>
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> ____UK_______April 8th
> ____UK_______April 22nd
>
> ____Denmark May 21-23rd
>
> ____USA_(FL)_May 2nd
>
>
> Next dates for the 3-day seminar:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____UK_(Manchester)_May
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: 20 March 2003 22:09
>
>
> > Paula,
> >
> > I'm not sure what would an MV on top of an
> aggregate
> > give me. I mean, I have a base table and I need to
> > aggregate. I can see doing it via an aggregate
> table
> > or (as someone suggested) via an MV. But you are
> > suggesting both. What benefit do you see from
> that?
> > What am I missing?
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
 |
 |