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

Constantine · May 8, 2019 12:17AM

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 · May 9, 2019 8:04AM

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 · May 9, 2019 4:19PM

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

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk