I have enought memory to load the whole database in obects.
I would like to read all the tables only once in the most efficient way and then have everything in cache.

Therefore, I would like the have a SELECT statement reading all the rows to run one and only one time on each table, with no joins and no where clauses.

Is this possible with Hibernate ?

If I have for example a class Customer with a ont-to-many collection pointing on Order, how can a single SELECT statement on the orders table populate simultaneously all the collections on all the Customer instances ?

Thanks