Hi.
I have a doubt:
If I make:
update stockline set status=3 where id IN (select id from lap_mpdetail_view where
lap=3976)
postgres makes an Seq Scan on stockline.
when stockline is big, it is better to make an select id from
lap_mpdetail_view where lap=3976) and programaticaly build the query of the
type update stockline set status=3 where id=X or id=Y or...
There must be a better way... EXISTS also make a seq scan
update stockline set status=3 where id = (select id from
lap_mpdetail_view where lap=3976); returns more than one tuple
Thanks
--
Pedro Miguel G. Alves [EMAIL PROTECTED]
THINK - Tecnologias de Informação www.think.pt
Tel: +351 21 413 46 00 Av. José Gomes Ferreira
Fax: +351 21 413 46 09 nº 13 1495-139 ALGÉS
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
