Posted by Robert Klemme on 04/10/06 17:52

--CELKO-- wrote:

> The other advanrtage of VIEWs in other SQL products is that they will
> be materialized and shared among sessions at run time, rather than
> re-computed over and over.

Even SQL Server has some support for materialized views although they
call it "indexed view".

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_6ptj.asp

Kind regards

robert

[Back to original message]