I have a UPDATE and INSERT query in table which is getting executed multiple times to update record (once every 5 seconds). This procedure is used in multiple procedures so the execution count is high, and I am getting deadlock issues on the UPSERT procedure even though the table has proper INDEXING and table level hints are placed.
I have tried lots but no luck in reducing the deadlock.
New contributor
HITESH KARSHINKAR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
6