title: What causes a high Scan Count in SQL Server IO Statistics?
body: <p>I understand that these are table or index scans that are being performed.  I'm a little unclear on what would cause some tables to have a large scan count while others would have a small scan count.  In a query I am looking at right now i am getting a scan count of about 150,000 on two tables in my query, while the rest have only a few.</p>
  
  <p>I'm guessing that "it depends" but if you could point me to something that might help me identify what is causing this it would be much appreciated.  Also if you are interested I could send you the query or any other info you might need.  I'd just rather not post it here.</p>