Discussion

1
Replies
198
Views
Close popover
Ramon Magsaysay II (Ramonm02)
Ernst & Young LLP

Ernst & Young LLP
US
Ramonm02 Member since 2015 11 posts
Ernst & Young LLP
Posted: November 18, 2015
Last activity: December 15, 2015
Closed

Using Optimizer Hint in Report Definition

Hi,

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.

 

Regards,

Ramon

 

System Administration
Moderation Team has archived post