What are Oracle Hints in Oracle Database Optimization?
It is a code snippet that is embedded into a SQL statement to suggest to Oracle how the statement execution should then occur.
When including Oracle Hints into a comment, they must be followed by a +- sign after the first keyword of the statement.
--+RULE /*+RULE */ One common Oracle hints is: ORDERED - with USE_NL to prevent hash join. Additional Information Oracle hints can be found at: http://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm Stay tuned for more Oracle hints and oracle hint information.