On Jan 26, 2011, at 10:52 AM, Jay Ramadorai wrote: > - Create views on temporary tables named by day. Have jobs go against the > views. When we are ready to rename, basically replace the view, pointing it > now to the new table of today. The key question here is: is the View metadata > consulted only upon query startup, or is it repeatedly looked at during query > execution. If only on startup, we might be able to get away this trick, until > concurrency truly works.
View metadata is consulted only while the query is being compiled, not during execution. JVS
