Why the time of masking of 2 similar tables differs so much?

Constantine

Hi, 

I have 2 tables A and B to mask, I am masking a single column using a substitution rule in each table with random 9 digits (%n%n%n%n%n%n%n%n%n). Table A has 180_000 rows and 38 columns; table B has 100_000 rows and 33 columns. Neither of them has triggers. Masking of A takes about 2 hours, masking of B takes about 1 minute. Could you please advise why it takes 120 times longer to mask table A that it takes to mask table B, and how it could be optimized.

Thank you,

Constantine

Eddie D

Hi Constantine, thank you for your forum post.

Does the advice in this help article, answer your question on how to optimize your substitution rule?

Many Thanks
Eddie

Constantine

Hi Eddie, 

Thank you for your response. I have reread the article and made some changes to the table structure adding an identity column. Now it runs very fast.

Thank you again,

Constantine