As the DB takes care of the maintenance of it, if I change a row in Customers, and it is in V's resultset, it is updated as well. you can of course schedule this (most of the time, data-warehousing is done on data harvested periodically, e.g. once a day).