How are views on views on views executed ??

From: Michael Keppler <Michael.Keppler_at_bigfoot.com>
Date: Tue, 28 Sep 1999 20:10:21 +0200
Message-ID: <7sqvq5$9ue@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:10:21 CDT