Home » RDBMS Server » Performance Tuning » how to increase the speed of a MView Refresh
how to increase the speed of a MView Refresh [message #209636] Sat, 16 December 2006 03:07 Go to next message
krishnahere
Messages: 1
Registered: December 2006
Junior Member
hi

I have a case where i need to improve the time of refresh of a MView. I am doing a complete refresh on a MView...
Please suggest me on the same...
Thanks!!
Re: how to increase the speed of a MView Refresh [message #209719 is a reply to message #209636] Sun, 17 December 2006 06:14 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Any possibility to make it FAST instead of FULL refresh?

Post the EXPLAIN of query(and a query itself) performing the refresh.

Previous Topic: Shared Pool Advisory for Shared Pool Size
Next Topic: Cost is high
Goto Forum:
  


Current Time: Sat Dec 10 09:14:51 CST 2016

Total time taken to generate the page: 0.08506 seconds