Views don't have any particular materialization or storage, it's just a select statement that is merged into your query every time you select something from the view. So to answer your question only changed tuple in the table is updated physically, views don't need to be updated. But in practical sense any occurrence of this tuple in result sets generated by all three views is changed, so all views are "updated".
Pavel On Tue, Oct 20, 2009 at 12:17 PM, Koston, Thorsten (ICT) <thorsten.kos...@harman.com> wrote: > Hello, > > i have a question about the update machanism for tuples in different > views: > > For example from a table we have three different views. > How will be the view updated if one Tuple updated or changed from the > DB? > (a) only the particular Tuple updated in the different view? > (b) or updated the complete views? > > Thank you in advance > > T. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users