On Mon, Sep 27, 2004 at 10:59:15AM -0600, Josué Maldonado wrote:
Hola,
> update product set pro_costcam = t.costo
> from (select coalesce(dpe_costol,0) as costo,
> dpe_procode2 as pcode
> from detpc a where dpe_pk
> in (select max(dpe_pk) from detpc b
> where b.dpe_productfk=a.dpe_productfk)) as t
> where rprodno=t.pcode
>
> El cual funciona bien sobre la tabla detpc que tiene solo 2,848
> registros,
Puedes mandar el EXPLAIN ANALYZE de esto? Que version estas usando?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"And as an added bonus, now my computer goes to the toilet for me, leaving me
free to spend time on more useful activities! yay slug codefests!" (C. Parker)