Let's say I have a (hypothetical) table with a name Table1with 500 columns and there is a view called View1, which is basically
select Column1, Column2,..., Column500, ComputedOrForeignKeyColumn1,...
from Table1
inner join ForeignKeyTables .....
Now that I am doing something like
Select Column32, Column56
from View1
which of the following 3 does SQL Server turn into?
Request No. 1:
select Column32, Column56
from
(select
Column1, Column2,..., Column500, ComputedOrForeignKeyColumn1,...
from
Table1
inner join
ForeignKeyTables ......) v
Request No. 2:
Select Column32, Column56
from Table1
Request No. 3:
select Column32, Column56
from
(select Column32, Column56
from Table1) v
, , , , ( ), , SQL , , , ( ..)... , .