I found the reason for my slow query (see post http://forums.hibernate.org/viewtopic.php?t=962617&highlight=&sid=f0f45225801f7de2e86036145e3eb81f)...it was a large clob column in my table. When I removed the column from the mapping file, the query results were fast.

The problem is I need this column to perform searches. This column is an indexed column used for Intermedia context searches (Oracle).

Is there any way to use this column to query, but not have it mapped in the results?

Example query:

I solved this issue by using Projection and implementing Dynamic Instantiation. In the Dynamic instantiation, I create the object leaving out the clob columns...

i.e.