Re: Hint is not used in SQL

That hint report and patch generation statement aren't consistent with the previous output.

*3 - SEL$AC90CD92 / PO_LINE_LOCATIONS_ALL_at_SEL$2 U -
 USE_NL_WITH_INDEX(_at_SEL$AC90CD92 PO_LINE_LOCATIONS_ALL_at_SEL$2) 5 -  SET$632CC7ED N - LEADING(_at_SET$632CC7ED VW_NSO_1_at_SEL$AC90CD92 PO_LINE_LOCATIONS_ALL_at_SEL$2) *

You have *_at_SET$632CC7ED* in the leading hint and that should be
*_at_SEL$AC90CD92. *

For an initial test of the patch I'd also use just use_nl() rather than use_nl_with_index().

Regards
Jonathan Lewis

--
http://www.freelists.org/webpage/oracle-l