Home » Server Options » Replication » Materialized views
Materialized views [message #109960] Wed, 02 March 2005 06:35 Go to next message
Messages: 70
Registered: March 2005
Location: delhi
does materialised views has any disadvantages..

Re: Materialized views [message #110077 is a reply to message #109960] Thu, 03 March 2005 06:40 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
From the top of my head:
- They actually use space to store data while a normal view does not.
- They require to be refreshed in order to reflect the latest data.

Re: Materialized views [message #216555 is a reply to message #110077] Mon, 29 January 2007 06:42 Go to previous message
Messages: 8
Registered: January 2007
Location: Chennai
Junior Member

Hi Maher,

While refreshing the materialised views it hangs up without bringing any result.
On the contrary the select query used in the materialised view takes just 10 to 20 minutes to retrieve the result.

Any idea.

Previous Topic: Improve Materialized View Refresh
Next Topic: Replication between 2 database with 1 source table to 2 or more target tables
Goto Forum:

Current Time: Tue Aug 22 19:46:59 CDT 2017

Total time taken to generate the page: 0.06798 seconds