I am creating a report on Infoset. My infoset contains four ODs Objects for Purchase requisition, PO item data, PO good Receipts and Accounts Payale data with left outer join. The issue i am facing is that query is taking very very high time to execute. Query results are ok. I had done following two things.
1. Created indexes in ODS
2. Increased cache size in RSRT tranaction.
But no improvement. Is there any other way to improve the performance so that query atleast starts running even if it is slow.