create view foo as select x,y,z from tab1 where a='b';
versus
create view foo as select x,y,z from tab1 where a='b' with read only;
Besides the obvious “it can not be updated”, what differences are there between two such views?
Any advantage in adding the WITH READ ONLY clause? Performance-wise?