by: jayanth.kurupPosted on:

Adaptive Joins SQL 2017

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'))

Please Consider Subscribing

Subscribe