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 for used tables and columns. Functions on the same tables never go parallel to prevent locking/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.