youtube.com youtube.com

Answering all of your questions - November 2019

In this Office Hours session we discussed:- How to compare large data sets efficiently- How to achieve massive performance even when you need to lock critical resources for serialisation- The anomaly of DML error logging versus triggers on the underlying tables- How to avoid SQL injection with the new SQL Macro features in 19c- Why pipelined functions might slow down even if the SQL within them is fastblog:...