Home » RDBMS Server » Server Administration » Performance hit with an Update?
Performance hit with an Update? [message #370014] Wed, 29 November 2000 12:57
Todd
Messages: 17
Registered: October 2000
Junior Member
I have a question. I am doing the following UPDATE which 9 times out of 10 updates no rows due to the where clause. Performance wise, would I be better off doing a SELECT first to check if the record exists and then do the update???

UPDATE processed
SET flag = 'N', delete_dt = sysdate
WHERE emp_id = rec.emp_id
AND policy = rec.policy

Thanks in advance
Todd

Report message to a moderator

Previous Topic: Translating Microsoft Transact SQL to PL/SQL.
Next Topic: Temp tbl query in stored proc creating performance issues-any thoughts?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 12 10:36:28 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.