title: WHERE clause better execute before IN and JOIN or after
body: <p>I read this article:
  <a href="http://msdn.microsoft.com/en-us/library/ms189499.aspx" rel="nofollow noreferrer">Logical Processing Order of the SELECT statement</a></p>
  <p>in end of article has been write ON and JOIN clause consider before WHERE.</p>
  <p>Consider we have a master table that has 10 million records and a detail table (that has reference to master table(FK)) with 50 million record. We have a query that want just 100 record of detail table according a PK in master table.</p>
  <p>In this situation ON and JOIN execute before WHERE?I mean that do we have 500 million record after JOIN and then WHERE apply to it?or first WHERE apply and then JOIN and ON Consider? If second answer is true do it has incoherence  with top article?</p>
  <p>thanks</p>