Details
-
Improvement
-
Status: Open
-
Normal
-
Resolution: Unresolved
-
None
-
None
Description
A view that has the same fields in the primary key as its base table (i call it a congruent key), does not require read-before-writes except:
- Range deletes
- Partition deletes
If the view uses filters on non-pk columns either a rbw is required or a write that does not match the filter has to be turned into a delete. In doubt I'd stay with the current behaviour and to a rbw.