>> In other words, when we have a view of a binary relation operation, are we necessarily creating a view of the entire expression, or are we making views of the operands? <<
In some SQL products, the optimizer looks at all the sessions that are
running. If a VIEW is shared among enough of them, then the VIEW is
materialized and treated like a base table. If a VIEW is not shared
among enough of them, then the VIEW is treated like an "in-line macro"
but it must always behave as if it were materialized.
Received on Sat Jul 15 2006 - 22:55:26 CDT
