UPDATE statement performance

[sacrsv]

Is there any better way of writing the following UPDATE statement?

DML statement:
UPDATE mytable SET obj_path = 80 WHERE obj_volumeid = 3 and obj_itemid LIKE 'A#%' AND obj_collectionid = 2 AND obj_path = 1;

Note:
1.The table has no partitions.
2.The table has >30 million rows.
3. The script has hundres of similar update statements with different values for obj_path, obj_volumeid, obj_itemid, obj_collectionid columns in mytable.

[skhanal]

Check if you can use FORALL loop. If should be possible if the parameters you pass can be generated based on loop counter.

[sacrsv]

Yes, FORALL loop works fine.

Thanks a bunch!