An Odd Performance Problem with Update - Twitter Thread

I came across an odd performance problem in some legacy Oracle PL/SQL code that I was able to resolve by replacing an update statement with a merge. I abstracted the essence of the problem using the simple table from my last blog post, plus a summary table. Unlike in the previous article, the simple update did not work very well. I made a short Twitter thread on my findings...

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production






Leave a Reply

Your email address will not be published. Required fields are marked *