title: Postgres query to make faster
body: <p>Any opinion on which query will be faster ( or no difference) and why?</p>
  <pre><code>select * from A a left join B b on a.id = b.cid where b.cl1 = 's1' or b.c1 ='s2' or b.c1 ='s3' ;
  </code></pre>
  <p>or</p>
  <pre><code>select * from A a left join B b  on a.id = b.cid where b.cl1 in ('s1','s2','s3');
  </code></pre>
  <p>The above is just examples to provide idea on what I am trying to do. May not be the exact syntax.</p>
  <p>The reason for asking the question is , I built up a spring-hibernate-JPA query similar to the first one and at this point performance is poor. Hence looking for all possible ways to make the performance better. It may or may not be the query. But not being expert on DB side, looking for information</p>