Remote query performance in BO reports [message #629726] |
Mon, 15 December 2014 12:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
lavk
Messages: 12 Registered: February 2010
|
Junior Member |
|
|
Hi Experts,
We some history tables at remote database.We are accessing these history data in BO reports using view.
These history tables containing the 85 million records.And BO reports are taking too much time to fetch those records in reports.
Is there any way we can minimize the round-trip in network to fetch those records in our reports/local database?
Thanks,
Lav
|
|
|
|
|
Re: Remote query performance in BO reports [message #630009 is a reply to message #629820] |
Thu, 18 December 2014 09:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
lavk
Messages: 12 Registered: February 2010
|
Junior Member |
|
|
Hi,
Thanks for Your reply!!
I have used 'Driving_site' hint but it is not so much useful. I have checked the query with and without this hint, it is taking almost same time to complete the query.
Thanks,
Lav
|
|
|
|