Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

REFRESH FORCE option in materialized views

Status
Not open for further replies.
sam93

sam93

Programmer
Joined
Jul 19, 2002
Messages
65
Location
CA
Hi,

Can someone please tell if REFRESH FORCE option is fast refreshable? If yes then what is the syntax for this?

Thanks.
 
Sort by date Sort by votes
Yes. "Refresh force" simply means that the materialized view will do a fast refresh, if it can. If it can't, then it will do a complete refresh. There is no syntax involved.

If you definitely must do a fast refresh, then don't specify "refresh force". Use "refresh fast" instead. That's what we use on our biggest materialized views. A complete refresh would take too long, so it's better for a fast refresh to fail than to attempt a complete refresh.
 
Upvote 0 Downvote
Thanks. Do we need to rebuild indexes in case of complete refresh? Also, in case of fast refresh, do we need to analyze the mat. view or the indexes?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question Question
Data encryption in Oracle 19c
Replies
0
Views
547
rk68
rk68
dampbluff
  • Locked
  • Question Question
Rumor About Forced Upgrade?
Replies
0
Views
934
dampbluff
dampbluff
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
annie1975
  • Locked
  • Question Question
sql script in an cron job script failing
Replies
3
Views
673
carp
carp
Livia8
  • Locked
  • Question Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC
Replies
5
Views
804
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top