rollback after 0 rows affected

I'm using transactions, with a delete followed by an insert. If the delete affects 0 rows, there is nothing to do. Do I need to rollback the transaction to abandon it, or is everything the way it should after a delete that affected 0 rows? Thanks! -- Sincerely, Fred Frederik Lindberg, CTO

Making rule-based optimizer choose correct index

by a unique scan of the D index. Adding nonsense criteria such as ... and D.UID 0 doesn't make things better. The D table is very wide, so a lot of I/O is wasted by doing a full table scan. Thanks! -- Sincerely, Fred Frederik Lindberg, CTO, CheetahMail -- Please see the official ORACLE-L FAQ