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

thanks
Re: Materialized views [message #110077 is a reply to message #109960] Thu, 03 March 2005 06:40 Go to previous messageGo to next message
Maaher
Messages: 7065
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.


MHE
Re: Materialized views [message #216555 is a reply to message #110077] Mon, 29 January 2007 06:42 Go to previous message
ashokkr24
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.

TIA
Ashok.
Previous Topic: Materialized Views
Next Topic: Materialize view complete refresh
Goto Forum:
  


Current Time: Fri Mar 29 10:36:47 CDT 2024