| 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: Materialized View Setup Strategy
Eric - I think you're going at it from the wrong direction. Start with which
queries perform badly and then see if you can create a MV to speed them up.
If the query does a SUM, then try to create a MV that will incorporate that.
If you're really stuck, start by creating a MV that IS the query. Just take
the query and slap it into a CREATE statement. If Oracle can't create a MV,
it will tell you in its own polite way. So you mess with it a little until
you figure out what you have to do to create a MV that your query can use.
With a little practice, you'll see how it works and start seeing commonality
in your queries so you can create a MV that will help several queries. Don't
forget you can create an index on a MV.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, May 20, 2003 11:22 AM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
We have a large scale data warehouse that are currently experiencing
performance problems. One of the areas that can be improved is summary
generation, which makes materialized views come in handy.
My question is - what is the best strategy in designing and implementing
materialized views? For example, how do you know which materialized view to
create? Since we don't have Oracle Dimensions defined in the database, I
don't think we can use summary advisor for now ( correct ? ). Are there any
gotchas?
Thanks
Eric
Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com>
Yahoo! Search - Faster. Easier. Bingo.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 20 2003 - 12:38:11 CDT
 |
 |