Are embedded views (Views within views...) evil and if so why?

[Robert Klemme]

Re: Are embedded views (Views within views...) evil and if so why?

--CELKO-- wrote:
[color=blue]
> 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.[/color]

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