Hi We have this query which was produced using discoverer.
The cost is only 18 but the query is producing massive nested loops which i think is the problem.
Please can someone help me re-write the query:-
SELECT /*+ PARALLEL(o102266,16,2) PARALLEL(o102270,16,2)*/ o102270.CLASSIFICATION_NAME...