At 12.23 02/03/02 -0500, Ann Harrison wrote:

>Changing the index to be on (n_mov, y_mov) would help

it was a typo, sorry.

The actual upgrade is

update mv_li set cod_cau=(select cod_cau from mv_hd where
mv_hd.y_mov=mv_li.y_mov and mv_hd.n_mov=mv_li.n_mov)

with an index on mv_hd(y_mov,n_mov)

I wanted to simply the example, but then wrote down the real index structure.

So the question is still there:

is there a better (faster) way to do the update ?

Thank you

Duilio