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 bkrike 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
Jul 19, 2002
65
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
Data encryption in Oracle 19c
Replies
0
Views
308
rk68
rk68
dampbluff
  • Locked
  • Question
Rumor About Forced Upgrade?
Replies
0
Views
811
dampbluff
dampbluff
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
880
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
510
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
599
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top