How to pass the hints to the SQL processor ? is there a way to do this ?
asked
How can we pass hints to the SQL processor?
You embed the hint directly in the SQL statement.
For example
SELECT /*+ NO_CPU_COSTING */ emp_name,
dpt_name,
grd_desc
FROM grade,
employee,
department department1
WHERE ...
The /*+ */ syntax starts and stops a hint.
