title: Clustered Index Scan instead of Clustered Index Seek on left join
body: <pre><code>SELECT *
  FROM
      tbl_transaction t
  LEFT JOIN
      tbl_transaction_hsbc ht
  ON 
      t.transactionid = ht.transactionid
  </code></pre>
  
  <p><code>transactionid</code> on both tables is the primary key so why no index seek?</p>