Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Policy Automation
Oracle Policy Automation - General Discussion
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 11, 2012 4:16 PM by
Use of Hints in performance tuning
Dec 11, 2012 11:30 AM
Please let me know actual usage of hints in query tunging, how do we write hints of increase performnace.
let me know below query will gives better performnce. if hints are not use query will degrade performance.
SELECT /*+ ORDERED INDEX (b, jl_br_balances_n1) USE_NL (j b)
USE_NL (glcc glf) USE_MERGE (gp gsb) */
FROM jl_br_journals j,
This content has been marked as final.
Show 1 reply
Re: Use of Hints in performance tuning
Dec 11, 2012 4:16 PM
in response to
You'll likely have better luck posting this to an Oracle database forum, such as this one:
The forum you have posted this to is for Oracle Policy Automation.