Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Ramon Magsaysay II (Ramonm02)
Ernst & Young LLP

Ernst & Young LLP
US
Ramonm02 Member since 2015 12 posts
Ernst & Young LLP
Posted: Nov 18, 2015
Last activity: Dec 15, 2015
Posted: 18 Nov 2015 11:23 EST
Last activity: 15 Dec 2015 4:44 EST
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

 

To see attachments, please log in.
System Administration

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice