In using Hibernate Criteria to do pagination, we were experiencing terrible performance. We came across this article: http://www.dba-oracle.com/t_sql_tuning_rownum_equals_one.htm that talks about using rank() instead of rownum for better performance.

Has anyone else seen this problem with Hibernate criteria? It looks like the dialect holds the rownum logic, but I don't know of a good way to override it on a case-by-case basis, and I really don't want a special dialect.