Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to force to use nested loop instead hash join

rafadbaDec 8 2017 — edited Dec 12 2017

sql.jpg

I would like to know how I could force a nested loop instead hash join. BUT I CAN'T use HINT, because this is a SAP standard system and I can't change the query.

I know I have some options like sqlpatch, sqlprofile, but I don't know how I use this features. Does someone can help me with a tutorial step by step?

Thank you so much.
This post has been answered by Franky Weber Faust on Dec 8 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2018
Added on Dec 8 2017
11 comments
3,814 views