title: Sql Server Join query
body: <p>I have two tables. one is a small table and another one is a large table. While joining between two table, which table i will keep in left and which one in right so that the query optimiser will search quicker or it does not matter where i will join the table..</p>
  
  <p>for example :</p>
  
  <pre><code>--1
  SELECT smalltable.column1,
         largetable.column1
    FROM smalltable
   INNER JOIN largetable
      ON smalltable.column1 = largetable.column1 ;
  --2
  SELECT smalltable.column1,
         largetable.column1
    FROM smalltable
   INNER JOIN largetable
      ON largetable.column1 = smalltable.column1 ;
  </code></pre>
  
  <p>Which query will make it faster or it doesnot matter.</p>