title: how to resolve preformance issue in IN Clause SQL Query for huge set of data?
body: <p>I am trying to query from the huge set of data. query keeps running without any result nor error. the same query I run for a small set of test data works fine.</p>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>&gt; SELECT * FROM table1 t1 WHERE t1.col1 IN (SELECT distinct(t2.col2)
  &gt; FROM table2 t2 Left Join table3 t3 on t2.col1 = t3.col1  WHERE
  &gt; t3.col1=value);
  </code></pre>
  
  <p>I am again tried to query for huge set of data with </p>
  
  <p><code>SELECT * FROM table1 t1 WHERE t1.col1 = (raw_value);</code> - single value filter works fine.</p>
  
  <p><code>SELECT * FROM table1 t1 WHERE t1.col1 IN ( raw_value, raw_value);</code> - more then one value filter gives performance issue.</p>
  
  <p>please give me suggestions to improve the performance.</p>
  
  <p>-thank you.</p>