Hi,

I run the explain plan on it already, it use index, and there only 4000 rows
in this table, this update statement only update

one row, the PK is the where clause combination.

column option_setting is using long data type,

all time is spend on "execute".

Cindy

Oracle LazyDBA home page