title: How to improve BigQuery performance for table scans?
body: <p>I have a table with some 80 million records of financial transactions.  I want to find every transaction above $100 million.  This query takes about 3 seconds, which will not work for my BI tool.  </p>
  
  <pre><code>% time bq query --nouse_cache 'select * from kc_imports.all WHERE VALUE &gt; 100000000'
  </code></pre>
  
  <p>The time results are:</p>
  
  <pre><code>0.35s user 
  0.10s system 
  15% cpu 
  2.899 total
  </code></pre>
  
  <p>Is there any way to drastically improve the time to complete the query?  If so, what are some tips?   Does Google Cloud provide some type of map-reduce tools perhaps?</p>
  
  <p>I should note here that subsequent query might be different, eg. I may want to also search for all transactions below $500.</p>