| Hi, I have a criteria with many inner join (about 13-14), but the generated SQL query has a different order. This causes performance problems because the SQL query takes about 140ms to be executed, and the criteria query (and SQL generated query) takes about 3 minutes !! See linked files : SQL_expected, SQL_generated by criteria, Criteria_written. SQL_generated.txt SQL_expected.txt criteria_written.txt |