Join order (Build/Probe, Outer/Inner) & Physical Operator Selection
In the past you always tried to make queries faster by starting joining with the smallest table and end with the largest one, or visa versa, whatever you did.. you never got it very fast.. now lets take a closer…