Statement « Performance « JPA Q&A

  1. JPA Q&A
  2. Performance
  3. Statement




1. performance of selects with in elements statements    forum.hibernate.org

I have a situation where because of some business requirement i often filter queries using an in statement that checks to see if a value is in a group of elements. That group of elements is fairly small; between 2-10. So I was wondering if it is more efficient to do a and (value = ? or value = ? or ...