1. order joins with parenthesis ((T1 JOIN T2 ON ... ) LEFT JOIN ... ) 2. use query hints : OPTION () clause ( example : OPTION(FORCE ORDER) ) 3. use join hints : () for control join type method 4. use table hints : WITH ( ) for control locks and index used on tableWith a strong hints setting you can fixed the query plan.