use tempdb;
go

if object_id('dbo.t1') is not null 
    drop table dbo.t1

if object_id('dbo.t2') is not null 
    drop table dbo.t2

create table dbo.t1
    (
      id int
    , val char(100)
    , constraint PK_T1 primary key clustered ( id )
    )

create table dbo.t2
    (
      id int
    , val char(100)
    , constraint PK_T2 primary key clustered ( id )
    )
go

;
with    cte ( id )
          as ( select   1
               union all
               select   id + 1
               from     cte
               where    id < 1000000
             )
    insert  into dbo.t2 ( id )
            select  id
            from    cte
    option  ( maxrecursion 0 );
go

;
with    cte ( id )
          as ( select   0
               union all
               select   id + 1
               from     cte
               where    id < 10
             )
    insert  into dbo.t1 ( id )
            select  id
            from    cte
    option  ( maxrecursion 0 );
go

-- на всякий случай :)
update statistics dbo.t1;
update statistics dbo.t2;
go

-- тест1 t1 join t2
select  *
from    t1
        inner loop join t2 on t1.id = t2.id	

-- тест2 t2 join t1
select  *
from    t2
        inner loop join t1 on t1.id = t2.id