> A view is a precomplied query yes?
NO, unless you're using an old version of DB2. Views aren't stored in
precompiled form, just as stored procedures aren't
stored in pre-compiled form. This is logical as the db engine has to determine
at runtime what the best execution plan is, so
storing views and other queries in pre-compiled, execute ready format will
likely run the risk of being slower at runtime.
FB
Therefore its unlikely
> ever to be less efficent than the same query. Unless, that is
> the data/indexs have changed significantly from when the
> query was created
>
> -----Original Message-----
> From: Discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED] On Behalf Of Dean Cleaver
> Sent: 11 August 2006 10:55
> To: [email protected]
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
>
> In my experience, that's not correct.
>
> -----Original Message-----
> From: Discussion of advanced .NET topics.
> [mailto:[EMAIL PROTECTED] On Behalf Of Frans Bouma
> Sent: Friday, 11 August 2006 19:13
> To: [email protected]
> Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question...
>
>
> A view is just a query, so a query utilizing a view
> isn't going to be slower than a query with the view's sql inside it.
>
> ===================================
> This list is hosted by DevelopMentor(r) http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>
> ______________________________________________________________
> _________
> This e-mail has been scanned for all viruses on behalf of
> United Kingdom Accreditation Service by Star Internet. The
> service is powered by MessageLabs.
>
> ______________________________________________________________
> __________
> This email is confidential and intended solely for the use of
> the individual(s) to whom it is addressed. Any views or
> opinions presented are solely those of the author and do not
> necessarily represent those of United Kingdom Accreditation
> Service. If you are not the intended recipient, be advised
> that you have received this email in error and that any use,
> dissemination, forwarding, printing, or copying of this mail
> is strictly prohibited.
>
> This e-mail has been scanned for all viruses on behalf of
> United Kingdom Accreditation Service by Star Internet. The
> service is powered by MessageLabs.
>
> ===================================
> This list is hosted by DevelopMentor. http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>
>
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
