Darryl Collins
Darryl.Collins at coles.com.au
Wed Oct 8 17:19:06 CDT 2008
wow... I would be really interested to read your results on this Arthur. Thanks for doing all this poking around on behalf of the list. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Thursday, 9 October 2008 4:15 AM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Views That is my understanding of the documentation, Susan. The view pulls everything to the client, which then filters out everything not interesting. I could be wrong about this but it would be relatively easy to generate a test. Unfortunately, today I have lots of work on my plate, but by tomorrow I will have a 50M row table on which to test this hypothesis. A. On Wed, Oct 8, 2008 at 2:03 PM, Susan Harkins <ssharkins at gmail.com> wrote: > > SELECT * FROM MyView WHERE PK = 124 > > > > results in the case of a view that all rows in the view are sent to the > > client and then the client filters the result set. > > =======Arthur, I'm not sure I understand -- are you saying that if MyView > contains 100 records but only 2 that satisfy the WHERE clause, the view > still pulls all 100 records but only displays 2? > > Susan H. > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.