Ramon Magsaysay II (Ramonm02)
Ernst & Young LLP

Ernst & Young LLP
Ramonm02 Member since 2015 11 posts
Ernst & Young LLP
Posted: November 18, 2015
Last activity: December 15, 2015
Posted: 18 Nov 2015 11:23 EST
Last activity: 15 Dec 2015 4:44 EST

Using Optimizer Hint in Report Definition


We are running a summary report and it took like 40 secs get the data back. We have 2 group by properties. The table is properly indexed. We run the query in Oracle directly and it still 40 secs to get the data. Our observation, it uses NESTED LOOP instead of HASH JOIN that causing the slowness to get the data.


We tried adding Optimizer Hint in the query and it get the data in just 2 secs.


Are there any options in Report Definition to use a Optimizer Hint or any configuration needed in Oracle DB to use HASH JOIN instad of NESTED LOOP?


Thank you in advance for your kind assistance.





System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.