title: Querying in Google bigQuery work slow
body: <p>I have a table which contains nearly a million rows. Searching for a single value in it takes 5 sec and around 500 in 15 seconds. This is quite a long time. Please let me know how can I optimize the query?</p>
  
  <p>My query is:</p>
  
  <pre><code>select a,b,c,d from table where a in ('a1','a2')
  </code></pre>
  
  <p>Job id  : stable-apogee-119006:job_ClLDIUSdDLYA6tC2jfC5GxBXmv0</p>