Hi,

From: "inoffensive_2006"

> This is an example of the SQL that's run for each row.
> UPDATE CON
> SET
> CON_ALPHA_SORT_ORDER = '1130038230440428'
> WHERE
> CON_KEY = '2301';

(...)

>sort order is calclated. All of the indexes for the table
>are altered to inactive,

I think you should *NOT* set the index on CON_KEY to inactive, or your
update statement will get slower!

Also, changing to {prepare, loop: set params for parametryzed query,
execute, end-loop unprepare}should have some gain too.


Regards,
Anderson