Well, in my experience that's not correct. I have a view that joined 3 tables. I used that view in other queries, but often the other queries were filtering a field in that view (which causes the whole view to be created in memory, and then filtered).
Adding those three tables to my second view with the same filtering was considerably faster. Dino -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Connolly, Paul Sent: Friday, 11 August 2006 22:15 To: [email protected] Subject: Re: [ADVANCED-DOTNET] SQL Server 2005 Xml question... A view is a precomplied query yes? 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(r) 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
