Don't know if it still does, but I think it used to influence the plan. Something about forcing join order? so you'd have

SELECT *
From TableX
INNER...