Views are (nearly) always completely expanded into the parent query, so even
four levels of views result in a huge, single query for the optimizer to
process.
Michael Keppler <Michael.Keppler_at_bigfoot.com> wrote in message
news:7sqvq5$9ue_at_TGZ3...
> Hello everybody !
>
> If I define some views which use other views (and so on), how are they
> executed ? Every view one after one on the result set of the other views
> or is the definition of every view put into the definition of the next
> view, making it one big query (and to my opinion much faster) ??
>
> So can I use much views on views on views... to not always repeat big
> (and in parts equal) queries or will this slow down the performance ??
>
> Ciao and Thanks, Michael.
>
> --
> Michael Keppler, MCSE, MCP+I
> IT logic GbR
> Michael.Keppler_at_gmx.de
>
>
Received on Tue Sep 28 1999 - 13:53:16 CDT
