I have a table (call it T1) made up of a join from two other tables
and a few calculated columns.
Currently, T1 gets refreshed by manually calling a function that does
the select on the join and then loops through each row doing an
update / insert as needed.
Obviously it would be nice to put this in a view so that I don't
have to worry about someone forgetting to call the refresh function.
My question (probably a common one):
When I select a single row from the view using WHERE will
the view build the calculated columns for every row regardless?
Thanks,
Matt