var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete from materialised view
Hey, i was wondering if the syntax for deleting from a materialised view
is the same as using the DELETE operator on a standard table?
Is this right?
DELETE FROM <View name>
WHERE a = b etc
A MV is not updateable (i.e. you cannot delete rows from it), it is updated through changes in the base table(s).
The only exception is, when you have the "Advanced Replication feature" and use the MV to replicate data between two servers.
To remove rows from the MV, delete them in the base table(s) and refresh the MV