Christopher Kings-Lynne wrote:
> What exactly is the advantage in using VIEWs? I get the impression that the
> SELECT query it is based on is cached (ie. a cached query plan).
I had the same impression but I've been told (with explanations) that
the query plan for a view is not cached in any way.
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925