title: Cassandra Allow filtering
body: <p>I have a table as below</p>
  
  <pre><code>CREATE TABLE test (
   day int,
   id varchar,  
   start int,
   action varchar,  
   PRIMARY KEY((day),start,id)
  );
  </code></pre>
  
  <p>I want to run this query</p>
  
  <pre><code>Select * from test where day=1 and start &gt; 1475485412 and start &lt; 1485785654 
  and action='accept' ALLOW FILTERING
  </code></pre>
  
  <p>Is this <strong>ALLOW FILTERING</strong> efficient? </p>
  
  <p>I am expecting that cassandra will filter in this order</p>
  
  <pre><code>1. By Partitioning column(day)
  2. By the range column(start) on the 1's result
  3. By action column on 2's result. 
  </code></pre>
  
  <p>So the allow filtering will not be a bad choice on this query.</p>
  
  <p>In case of the multiple filtering parameters on the where clause and the non indexed column is the last one, how will the filter work?
  Please explain.</p>