title: Best database for multi million row store/query
body: <p>We have a database that has been growing for around 5 years. The main table has near 100 columns and 700 million rows (and growing). </p>
  
  <p>The common use case is to count how many rows match a given criteria, that is:
  select count(*) where column1='TypeA' and column2='BlockC'.</p>
  
  <p>The other use case is to retrieve the rows that match a criteria.</p>
  
  <p>The queries started by taking a bit of time, now they take a couple of minutes. 
  I want to find some DBMS that allows me to make the two use cases as fast as possible.</p>
  
  <p>I've been looking into some Column store databases and Apache Cassandra but still have no idea what is the best option. Any ideas? </p>