Views and Query Optimizer

microsoft.public.sqlserver.programming

22 Jun 2006 9:52 AM

sorinr

Hi all,

Supose I have a view that combines fields from multiple tables. When I
select something from this view, does the query optimizer know to 'use'
just the fields specified in the SELECT statement and in the WHERE
clause (if any)?

Thanks,

Sorin

22 Jun 2006 10:01 AM

DM Unseen

Even if you will use only some of the fields of some of the tables, the
optimizer will still need to match all inner joins.

DM Unseen
sorinr schreef:

Show quote

> Hi all,
>
> Supose I have a view that combines fields from multiple tables. When I
> select something from this view, does the query optimizer know to 'use'
> just the fields specified in the SELECT statement and in the WHERE
> clause (if any)?
>
> Thanks,
>
> Sorin