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

Report message to a moderator

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: 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.


MHE

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 30 00:17:22 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.