[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.
>