USE_NL and INDEX hints example

select /*+ USE_NL(A,B) INDEX(a ATS_FLORIST_FITTYPE_I)*/ a.FIT_ID

from

ATS_FLORISTS a,ATS_FLORISTS_TRACKING b where b.FIN_PROC = ‘N’ AND

b.OLD_FRESH_PAY = ‘Y’ and b.NEW_FRESH_PAY=’N’ and a.FIT_TYPE=’P’ and a.ID=

b.fit_id