This content has been marked as final.
Show 1 reply
-
1. Re: query on Updatable materialized view
shawkins Aug 12, 2015 10:34 AM (in response to rupeshsingh01)> OR we need some custom ways ?
The refreshMatViewRow or refreshMatViewRows for Internal materialization operates over just primary keys on the view, so you need to know the primary key of what is affected.
We will be looking to consolidate the refresh logic with the SYSADMIN.updateMatView procedure that is currently for external materialization. It is a little more flexible in that you can specify a predicate to determine what rows need updating.