Home » Developer & Programmer » Data Integration » Time to take complete Refresh MATERIALIZED VIEW
Time to take complete Refresh MATERIALIZED VIEW [message #93170] Tue, 20 May 2003 15:58 Go to next message
purrukrishnamoorthy
Messages: 1
Registered: May 2003
Junior Member
Hai,

we have a Materialized view containg 90days data.
Approximatelly 200,000 records.data is wrongly poplulated into the Materialized view.we would like to do complete refesh of the materialized view.please let me know how much time it takes for complete referesh.
The materialized contains Joins,Aggregates and 200,000 records.

Regards
Purru
Re: Time to take complete Refresh MATERIALIZED VIEW [message #93204 is a reply to message #93170] Thu, 25 September 2003 13:27 Go to previous message
Manish
Messages: 79
Registered: December 2000
Member
How long a refresh takes will totally depend on the query that is run by the database. Tune the quey and it will be faster.

Manish
Previous Topic: Daily data population
Next Topic: Datawarehousing
Goto Forum:
  


Current Time: Thu Mar 28 07:44:59 CDT 2024