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.