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: 7064
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: Materialized Views
Next Topic: Materialize view complete refresh
Goto Forum:

Current Time: Thu Mar 30 00:17:22 CDT 2023