MS SQL Data Warehousing

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

View

Travis

2005-09-27, 3:23 am

Hi ,

What is the difference I create a view from TableA with 3 fields and I
select 3 fields from TableA ? Let's assume TableA have 20 field attach to it

Will it increase the performance when I select from view ?

--
Travis Tan

Marcin Pêksa

2005-09-27, 7:23 am

The view only simplifies access to the table. Instead of using a subquery
you can use a predefined view. It does not impact the query's performance.

Marcin

U¿ytkownik "Travis" <Travis@discussions.microsoft.com> napisa³ w wiadomo¶ci
news:BB97F1B2-78D7-4759-859E- 653966A9B28F@microso
ft.com...
> Hi ,
>
> What is the difference I create a view from TableA with 3 fields and I
> select 3 fields from TableA ? Let's assume TableA have 20 field attach to
> it
>
> Will it increase the performance when I select from view ?
>
> --
> Travis Tan

Sponsored Links