Does SQL Server extend sql representation inside a row at runtime?

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 , , , ( ..)... , .

+4
3

SQL Server :

. . .

- , . , . .

, , , , .

: , . -, UPDATEs .

+2

. SQL Server , . , ..

, , .

. ? .

+1

. , , QO.

, , ( , IF EXISTS). FK, QO , , , .

+1

Source: https://habr.com/ru/post/1654397/


All Articles