How to pass the hints to the SQL processor ? is there a way to do this ?
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.
No one has followed this question yet.