I have to run a query against MySQL DB in order to retrieve some data. Let's say that we have the following table:

ID | COLUMN_1 | COLUMN 2
---+-----------+-----------
1 | AAA | BBB
2 | CCC | DDD
...

and the query should look like this one: select * from TABLE where (COLUMN_1 = AAA and COLUMN_2 = BBB) or (COLUMN_1 = CCC and COLUMN_2 = DDD) or .... In this case we have only 2 OR operators but this number can be up to 700 and the query will be dynamic - sometimes there will be one OR sometimes will be 5 hundred ORs.

How would you recommend to implement it using Hibernate? The most important thing is performance.

Thanks.