We are currently looking at Hibernate and I have a few questions regarding it,

1) How to fine tune the queries which Hibernate generates? Our DBA needs to fine tune the query which hibernate generates for loading saving etc. Is that possible?
2) We have shadow tables for each table for audit purpose, Can somebody suggest a corect procedure to insert into that shadow table when the main table is updated; I was thinking of using interceptors.
Thanks in advace for your help.
Puru

What do you mean exactly by "fine tune"? You can within some bounds manipulate the way Hibernate loads objects by using outer-join, lazy, etc.

Why don't you simply use a database trigger for that shadow tables?

Shadow table/s has extra information than the actual table/s like the user information etc

This kind of tuning is very trivial, SQL query is used in "EXPLAIN PLAN FROR " to eleminate table scans (create index).

It is possible to log dynamic queries in JDBC Driver wrapper and to collect statistics about expensive queries, there is nothing hibernate specific.

BTW "EXPLAIN" is a good thing for development, I use it to validate query on app startup in debug mode, It can be usefull for named queries in hibernate too.

I do something very similiar in a custom interceptor.

Take a look at http://hibernate.org/156.html

My Interceptor actually not only coordinates the validation shown there, but also does some pushing of domain events (that code is not shown in the link above). However, it'd be pretty easy to get the code show to populate a shadow table.