This content has been marked as final. Show 4 replies
1)check in the Report any Cast,Nvl function are used,some times these will degrade the perf.
2)Try to limit the values with filters in Reports or where conditions in RPD,Implement fragmentation if tables data is large to avoid whole table search,with fragmentation we will achieve smaller tables and search time is less..
3)check the joins properly
4)Check whether the indexes are applied or not in Database.
5)Cache is enabled or not
6)if possible try to partition large tables into smaller tables by using some portioning techniques
5)use Hints in RPD.
Hi User ,
Thanks for your quick reply .
I will take all the above considerations for improving the performance of the report.
But i want exact answer from where we have to start the investigation weather from DB or RPD or WEB.
Hi Rafi,1 person found this helpful
First take OBIEE query and try to execute in Database and check it time, similarly check the time sql query in database.(You can identify the where it will take time too much).
The result output says Database:-
Create Index, partitions you can improve performance.
Check join conditions, try to use aggregate tables, try to use Filter conditions instead of case statements and enable to cache mechanism.
Hope this help's
I faced the same situation but i found one which is given the good stuff to me.Please refer this link.
mark if helpful/correct....