Best Practices for use of DML in PL/SQL

I am one at one of those points where there is more than one way to perform a task and due to inexperience I am not quite sure which option is best.

I have a PL/SQL procedure that performs an UPDATE DML operation. I can perform the update in one of 2 ways depending on a flag value that is passed to the procedure.

Do I :

1. Use one UPDATE statement with an OR in the WHERE clause
2. Use 2 UPDATES and decide which one to use based on the flag value?

I'm going to use option b) because it makes the code clearer and I remember something about ORs not performing too well.

What do you think? Received on Thu Mar 13 1997 - 00:00:00 CST