title: Does Sql JOIN order affect performance?
body: <p>I was just tidying up some sql when I came across this query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT 
          jm.IMEI ,
          jm.MaxSpeedKM ,
          jm.MaxAccel ,
          jm.MaxDeccel ,
          jm.JourneyMaxLeft ,
          jm.JourneyMaxRight ,
          jm.DistanceKM ,
          jm.IdleTimeSeconds ,
          jm.WebUserJourneyId ,
          jm.lifetime_odo_metres ,
          jm.[Descriptor]
  FROM    dbo.Reporting_WebUsers AS wu WITH (NOLOCK)
          INNER JOIN dbo.Reporting_JourneyMaster90 AS jm WITH (NOLOCK) ON wu.WebUsersId = jm.WebUsersId
          INNER JOIN dbo.Reporting_Journeys AS j WITH (NOLOCK) ON jm.WebUserJourneyId = j.WebUserJourneyId
  WHERE   ( wu.isActive = 1 )
          AND ( j.JourneyDuration &gt; 2 )
          AND ( j.JourneyDuration &lt; 1000 )
          AND ( j.JourneyDistance &gt; 0 )
  </code></pre>
  
  <p>My question is does it make any performance difference the order of the joins as for the above query I would have done </p>
  
  <pre><code>FROM dbo.Reporting_JourneyMaster90 AS jm
  </code></pre>
  
  <p>and then joined the other 2 tables to that one</p>