DATPROF Privacy and Subset have the setting PARALLEL. I read scripts never go PARALLEL. Why not?


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.