Hi Guys,

I am using Hibernate + Oracle 10g in my application.

What is the problem is i want to show the page with getting the values from 3 tables and one Views and one page can contain 100 records.

So wht i am do is Suggn_id is the primary key, so first i retrieve the suggn_id , and i write another four queries for each table to retrieve the value based on that suggn_id. it will take 10ms to load the page.

any one can suggest me how to improve the performance fast to load the page quickly...

Thanks in advance.

Regards,
Bala