Adaptive Joins SQL 2017

By | June 20, 2019

 

select a.StateName , a.CityName ,
sum(flights)
from Airports a

inner
join normalization_index n

on a.AirportSeqId = n.OriginAirportSeqID

where a.AirportSeqId > 1474703

group
by a.StateName , a.CityName

 


 

select a.StateName , a.CityName ,
sum(flights)
from Airports a

inner
join normalization_index n

on a.AirportSeqId = n.OriginAirportSeqID

where a.AirportSeqId=1451202

group
by a.StateName , a.CityName

 

 

select a.StateName , a.CityName ,
sum(flights)
from Airports a

inner
join normalization_index n

on a.AirportSeqId = n.OriginAirportSeqID

where a.AirportSeqId > 1474703

group
by a.StateName , a.CityName

OPTION (USE HINT
(‘DISABLE_BATCH_MODE_ADAPTIVE_JOINS’))