When you have chance, please share you knowledge about parallel degradation, i.e. parallel query gets serialized. Why happens, how to check, and how to get around it. Thanks.
Thanks a lot! Awesome contest, super useful! I have some questions: Maybe I’m not getting this right, but readying the docs and to an execution plan makes me understand that it’s not possibile to use parallel hints on table with foreign key, is that correct? Isn’t that a big constraint? I mean in real world application, I think table usually do have foreign key. People advice me to remove temporarily foreign key costraint, do the parallel insert, and then put the costraint up again, but doesn’t this makes the fk costraint useless in the first place?
Parallel is about making massive operations faster. Checking the FK during such an operation is sort of the antithesis of that . Parallel DML locks the table, so its not as if you will having other transactions going on at the same time, hence temporarily disabling the FK becomes a more palatable option