title: Subquery v/s inner join in sql server
body: <p>I have following queries</p>
  
  <p>First one using inner join</p>
  
  <pre><code>SELECT item_ID,item_Code,item_Name 
  FROM [Pharmacy].[tblitemHdr] I 
      INNER JOIN  EMR.tblFavourites F ON I.item_ID=F.itemID
  WHERE F.doctorID = @doctorId AND F.favType = 'I'
  </code></pre>
  
  <p>second one using sub query like</p>
  
  <pre><code>SELECT item_ID,item_Code,item_Name from [Pharmacy].[tblitemHdr]
  WHERE item_ID IN
  (SELECT itemID FROM EMR.tblFavourites
  WHERE doctorID = @doctorId AND favType = 'I'
  )
  </code></pre>
  
  <p>In this item table <code>[Pharmacy].[tblitemHdr]</code> Contains 15 columns and 2000 records. And <code>[Pharmacy].[tblitemHdr]</code> contains 5 columns and around 100 records. in this scenario <code>which query gives me better performance?</code></p>