title: How would you optimize this SQL Server 2008 R2 Table
body: <p>I have a private messaging system for my browser game. When I check most CPU time using queries I see that this table is the most CPU using one. I am not good with indexes, query time optimization. So I would like to get your optimization tips about this table. </p>
  
  <p>Alright now I am going to show you table structure first:</p>
  
  <p><em>structure image</em></p>
  
  <p><img src="https://i.stack.imgur.com/5qqJW.png" alt="enter image description here"></p>
  
  <p>Alright this following query reads how many unread messages does user have and this query is the most CPU using one since it reads at every page load:</p>
  
  <pre><code>SELECT COUNT([Id]) [Number] 
  FROM [MyTable] 
  WHERE [ReceiverUserId] = @1 
    AND [ReceiverReaded] = @2 
    AND [ReceiverDeleted] = @3
  </code></pre>
  
  <p>So what kind of indexes etc might improve my performance?</p>