Hi Friends,

I am trying to use the oracle index (index is already created in oracle database) .
have added the following line in hbm file for enabling the index but it seems giving no impact on performance , the data is about in multiple tables and each having more then 50 millions of record

<column name="SOMEID" precision="12" scale="0" index="SOME_PK"/>
kindly tell me if i am doing the right thing or do i need to enable some property in hibernate config file.

is there any other any ways to improve the performance for fetching the records from the DB , am using the mem-cache and connection pool.