Re: Weekly aggregates

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 ----- From: "Gurelei" <gurelei_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 20 March 2003 22:09 Subject: RE: Weekly aggregates

> 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?
Received on Thu Mar 20 2003 - 17:48:59 CST