Home » SQL & PL/SQL » SQL & PL/SQL » materialized view question (10.0 win xp)
materialized view question [message #344623] Sun, 31 August 2008 02:24 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am planning to make a materialized view for a frequently used query which joins multiple tables and all these tables are huge

I am trying to understand the impact it may have on the system.

CREATE MATERIALIZED VIEW catalog   
   REFRESH FAST START WITH SYSDATE NEXT  SYSDATE + 1/1440
   WITH PRIMARY KEY 
   AS SELECT * FROM a, b, c, d ...; 


As shown above (dummy query) this materialized view is being refreshed every 1 minute. Does this mean that every one minute the query in this view will be regenerated (optimized, parsed, fetched etc). This might prove to be a huge load on the system.

Please let me know what you think

Re: materialized view question [message #344666 is a reply to message #344623] Sun, 31 August 2008 17:48 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:10128040625700
Re: materialized view question [message #344674 is a reply to message #344666] Sun, 31 August 2008 22:39 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
got it...thanks
Previous Topic: Advance Distinct Check.
Next Topic: error in union with order by clause
Goto Forum:
  


Current Time: Sun Dec 08 07:39:22 CST 2024