How to pass the hints to the SQL processor ? is there a way to do this ?
asked Jan 06, 2010 at 10:20 AM in Default
You embed the hint directly in the SQL statement.
SELECT /*+ NO_CPU_COSTING */ emp_name, dpt_name, grd_desc FROM grade, employee, department department1 WHERE ...
The /+ / syntax starts and stops a hint.
answered Jan 06, 2010 at 11:06 AM