Hi there, I was in troubles with a UPDATE+IN statement:
The following command use to take about 5 minutes to be done: UPDATE requisicao SET conclusao='3' WHERE reg IN (SELECT reg FROM requisicao WHERE now()-data>'15 days'); The table 'requisicao' has only about 400 lines (!!). If I change it to: UPDATE requisicao SET conclusao='3' WHERE reg IN (12, 45, 87, 98, 129, 350, 389); I have detected that the major problem isn't in the amount of lines changed, but in the subselect. How can I solve/optimize it? I would like to use the IN, but in the last case I would make a software change. Thanks in advance and Best regards, Marcelo Pereira Brazil Yahoo! Mail - o melhor webmail do Brasil http://mail.yahoo.com.br ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
