title: Is it possible to review/optimize a Hibernate query plan?
body: <p>Is there some facility in Hibernate for viewing the query <em>plan</em> for a query? I can look at the source code and trace the joins and eager fetches and hope that I don't miss any, or I can look at the SQL log and try to match up a SQL statement with its source, but I was wondering if there was a faster way. e.g., I can imagine an object diagram showing the relevant classes or an E-R diagram with some kind of sequencing notation.</p>