String hql = "from A a, B b where a.id = b.id and a.value in(:values)";
Query query = session.createQuery(hql);
query.setParameterList("values", {1,2,3});
List list = query.list();

table A contains 10,000+ records, table B contains 30,000 records;
id is the pk of A, and B has a pk(id + name)
the query result contains about 20,000+ records
but the query cost 6 to 10 mins

how should i reduce the query time

Analyze what your DB is doing with that statement and create some useful indexes.

thanks for your reply.
a.id is the primary key. and I created a index on a.value and b.id each other.
but that does not make any change.

then i used jdbc to do the query. and it just cost 2 to 3 seconds.
this is the jdbc sql : "select a.id, a.value, b.id from a, b where a.id = b.id and a.value = ?";

I want to know what makes such a big difference.
and how should i reduce the hibernate query time.