Improving Performance of a multidatabase report

Hi All,

This is regarding multiple database reprot.

I am getting a query from mysql like this .

SELECT * FROM OBJSETTING_DATA

and other query from oracle like this.

select country,empno from HO_USERS

and other also from oracle like this

select linemanager,empno from hr_apps

And the parameters are year,division,Status.And I am linking empno using cr links tab

May be I will have some hundreds of records only.

In my report I need show country,empno,name,linemanager,grade,status.

So here country,linemanager coming from oracle and rest of all coming from mysql.

Please suggest what are the steps to follow to improve performance.