Why do SQL scripts never run parallel?
Situation
DATPROF Privacy and Subset have the setting PARALLEL. I read scripts never go PARALLEL. Why not?
Explanation
During execution, Privacy and Subset check which tables and columns are being used. Functions on the same tables do not run in parallel to avoid locking or missing data issues.
Ok, that's not about the scripts.
Well, because Privacy and Subset cannot predict which tables and columns are used in your scripts they cannot prevent locking/missing data issues when running parallel.
That's why SQL scripts will run on their own.