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.
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