OraFAQ Forum: Performance Tuning » how to increase the speed of a MView Refresh

Home » RDBMS Server » Performance Tuning » how to increase the speed of a MView Refresh

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to increase the speed of a MView Refresh [message #209636]

Sat, 16 December 2006 03:07

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!!

Report message to a moderator

Re: how to increase the speed of a MView Refresh [message #209719 is a reply to message #209636]

Sun, 17 December 2006 06:14

michael_bialik
Messages: 621
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 10:43:10 CST 2024