Consider the following query:
If there is an index (a, b), it will not be used properly: only column a will be used. This will leads to multiple unnecessary comparisons.
Most obvious way to fix that - use temporary table and JOIN. However, this approach doesn't work well when there are multiple IN's.
Proper solution would be to hack deeper into H2.