How to load records effectively in Hibernate

Question

I have a database of one million records with 50 columns. I have an ORM model of Hibernate. The problem is that my page size is 200 rows. But, I want to fetch only 5 records. How can I achieve it without using a criteria API?

Answer 1

Use the setMaxResults() method from the Query class.