I asked this question on the sql server forum since we're coding against as400 and sql server. I like to know the answer with AS400 as well:
we have a table with 422276 rows. We could have less rows or even more but in one database, it's that many. There is one field to update in that table:
update table set field='ppp' where field1='lll' and field2='nnn'
That can be using the table. My coworker created a Logical (view in sql server):
create view myView as select <all fields> from table where field1='lll' and field2='nnn'
*** and to update that table he uses the View: update MyView set field='ppp' where dateField > '2007-04-04'
*** Is there any benefit to using a view/logical to do this update?? He has the update in a stored proc and the stored proc uses the view/logical to update the table. I see it as unnecessary.