[dba-SQLServer] Views

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.





More information about the dba-SQLServer mailing list