Re: Materialized view selection.

2002-08-19 Thread Maria Aurora VT de la Vega

Depends mostly on your users needs. If most of the time your users would want monthly 
sum of measures, you give them a
materialized view for that.
You can also use the summary advisor feature of oracle (dbms_olap) to find out which 
mviews oracle thinks is needed based on
usage.

=)

Chuan Zhang wrote:

 Hi, All,

Just wonder what's tool or methodology you are using to select materialized view 
in Oracle data warehouse environment?

 Many thanks in advance,

 Chuan

   
Name: InterScan_Disclaimer.txt
InterScan_Disclaimer.txtType: Plain Text (text/plain)
Encoding: 7bit

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).



Materialized view selection.

2002-08-18 Thread Chuan Zhang

Hi, All,

   Just wonder what's tool or methodology you are using to select materialized view in 
Oracle data warehouse environment?

Many thanks in advance,

Chuan


Unless otherwise stated, this e-mail does not represent the views of 
TransACT Communications Pty Limited.  This text and any attachments of 
this e-mail are confidential and may be legally privileged.  This email 
is for the use of the intended recipient only. If you are not the intended 
recipient do not take any action in relation to this email, other than to 
notify TransACT Communications by replying to this e-mail and destroying 
the original communication.  Except as required by law, TransACT 
Communications does not represent that this transmission is free of errors, 
viruses or interference.