Please find my response below. Similar issue occurred again, so replying on old thread.
1/ Database type- Maria DB2/ Number with columns type and tables you are masking- One Column- 210 Million records - It took 11 Hrs. to complete the Masking 3/ Any index, constraints or triggers on the subject column(s)- Yes, But enabled DROP INDEXES option4/ Masking job configuration and used algorithms - Only one AL- Business Legal Entity SL- System SL
5) Min- 1GB and Max 16 GB assigned in Masking Job.
Please advise how to improve the Masking job?
Here is a first approach you can try and let me know how it goes and we can refine it if needed :Can you confirm please the engine version you have too ?
Let me know how did this go for youBest,
100 GB / 480min = 0.2 GB / minThis number seems to be a bit slow. General advise is to drop indexes/triggers/constraints on masked columns and make sure an appropriate logical key is being used (indexed!).Please provide details :
1/ Database type2/ Number of columns and tables you are masking3/ Any index, constraints or triggers on the subject column(s)4/ Masking job configuration and used algorithms
Oracle specific optimisations: