title: Efficient query in SQL Server?
body: <p>Can anyone think of a better way to write below query in SQL Server, since this one does a full table scan?</p>
  
  <pre><code>DELETE FROM tablename
  WHERE EXISTS (SELECT 1 
                FROM view a, tablename b
                WHERE (a.rk = b.rk
                  AND a.tdate = b.tdate
                  AND a.locid = b.locid
                  AND a.itemid = b.itemid))
  </code></pre>