Tuning Updates

Consider the following update statement:

update /*+ index(t1 t1_n1) */ t1
set
        n1 = 0,
        n2 = n2 + 1,
        status = 'X'
where
        n1 > 100
and     status = 'A'
;