Hi,
I am using Hibernate with Spring and have come across this strange problem.
There is a table A which was not partitioned before.
However to optimize certain queries, it was partitioned on one of the columns.
With this change, other queries which do not use the partitioning on the view over the table seem to become slow...
The strange part is that these queries which do not use the partitioning columns seem to be slow only when executed from Hibernate and seem to be very fast when executed from a SQL client like SQLPlus or TOAD.
Is it expected? What are the reasons for it? What can be done to avoid it?
Thank you
Rahul
_________________ Rahul
|