Why the time of masking of 2 similar tables differs so much?
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.
0 · Share on Twitter