title: Cassandra Performance SELECT by id or SELECT by nothing
body: <p>I am wondering if C*s <code>SELECT</code> speed depends on how we select whole finite tables.</p>
  
  <p>For example we have this table</p>
  
  <pre><code>id | value
  A  | x
  A  | xx
  B  | xx
  C  | xxx
  B  | xx
  </code></pre>
  
  <p>Would it be faster to get all the results if we would do<br>
  <code>SELECT * FROM Y WHERE id='A'</code><br>
  <code>SELECT * FROM Y WHERE id='B'</code><br>
  <code>SELECT * FROM Y WHERE id='C'</code></p>
  
  <p>or would it be faster if we would do<br>
  <code>SELECT * FROM Y WHERE 1</code></p>
  
  <p>or maybe would it be faster if we would do<br>
  <code>SELECT * FROM Y WHERE id IN ('A', 'B', 'C')</code></p>
  
  <p>Or would they be equally fast ( if we dismiss connection time )</p>