Rules for Updating Rows Using Views
To update rows using a view through which the table is accessed, observe the following rules:
The immediate owner of the view (that is, the containing database for the view) must have the UPDATE privilege on the underlying object (view, base table, or columns) whose columns are to updated, and the SELECT privilege on all tables that are specified in the WHERE clause.
Although you can generally convert the data type of a view column (for example, from VARCHAR to CHARACTER), if that converted column is a component of an index, then the Optimizer does not use that index when the base table is updated because the data type of the recast column no longer matches the data type of the index column.
The resulting all-AMP, all-row scan defeats the performance advantages the index was designed for.