title: Why Select SQL queries on tables with blobs are slow, even when the blob is not selected?
body: <p>SELECT queries on tables with BLOBs are slow, even if I don't include the BLOB column. Can someone explain why, and maybe how to circumvent it? I am using SQL Server 2012, but maybe this is more of a conceptual problem that would be common for other distributions as well.</p>
  
  <p>I found this post: <a href="https://stackoverflow.com/questions/11671226/sql-server-select-on-a-table-that-contains-a-blob">SQL Server: select on a table that contains a blob</a>, which shows the same problem, but the marked answer doesn't explain why is this happening, neither provides a good suggestion on how to solve the problem.</p>