RE: Optimize code?

2007-04-30 Thread Jerry Schwartz
Thanks, Jay. Comments interspersed... > Jerry Schwartz wrote: > > I need (ultimately) to update some prices in a prod_price > table. First, I > > need to locate a product and its associated prices using a field > > prod.prod_price_prod_id which is not unique, and is often > null, but it is > > in

Re: Optimize code?

2007-04-27 Thread Jay Pipes
Hi Jerry, comments inline Jerry Schwartz wrote: I need (ultimately) to update some prices in a prod_price table. First, I need to locate a product and its associated prices using a field prod.prod_price_prod_id which is not unique, and is often null, but it is indexed. (Subsequent operations