Materialized View Setup Strategy

From: eric lee <warehousedba2003_at_yahoo.com>
Date: Tue, 20 May 2003 08:21:42 -0800
Message-ID: <F001.0059DEE3.20030520082142@fatcity.com>

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 Yahoo! Search - Faster. Easier. Bingo.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: eric lee
  INET: warehousedba2003_at_yahoo.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 - 11:21:42 CDT