Re: Tuning Question......

There's not enough selectivity for the nested loops.

Try adding indices that include the product_code and origin.

See also nested loops in your versions performance tuning guide.

See http://www.dbaoracle.net/readme-cdos.htm

jg

-- 
@home.com is bogus.
http://www.elseware.to/products/aq.htm