子查询的执行计划

SET STATISTICS PROFILE ON

EXIST关联子查询：

select * from tb_1 A where exists(select 1 from tb_2 B where B.id=A.id) ;
--select * from tb_1 A where exists(select 1 from tb_2 B where B.id=A.id) ;
--   |--Nested Loops(Inner Join, OUTER REFERENCES:([B].[Id]))
--       |--Clustered Index Scan(OBJECT:([tempdb].[dbo].[Tb_2].[Pk_Tb_1] AS [B]))
 --          |--Clustered Index Seek(OBJECT:([tempdb].[dbo].[Tb_1].[Pk_Tb_11] AS [A]), 
              --SEEK:([A].[Id]=[tempdb].[dbo].[Tb_2].[Id] as [B].[Id]) ORDERED FORWARD)




IN非关联子查询：

select * from tb_1 A where A.id in (select B.id from tb_2 B where B.id=A.id) ;
--  select * from tb_1 A where A.id in (select B.id from tb_2 B where B.id=A.id) ;
--    |--Nested Loops(Left Semi Join, WHERE:([tempdb].[dbo].[Tb_2].[Id] as [B].[Id]=[tempdb].[dbo].[Tb_1].[Id] as [A].[Id] 
       --AND [tempdb].[dbo].[Tb_2].[Id] as [B].[Id]=[tempdb].[dbo].[Tb_1].[Id] as [A].[Id]))
--        |--Clustered Index Scan(OBJECT:([tempdb].[dbo].[Tb_1].[Pk_Tb_11] AS [A]))
--             |--Clustered Index Scan(OBJECT:([tempdb].[dbo].[Tb_2].[Pk_Tb_1] AS [B]))



 SET STATISTICS PROFILE OFF

执行顺序是什么？