How can we help you today? How can we help you today?

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

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
Constantine
0

Comments

2 comments

Sort by
  • 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
    Eddie D
    0
  • 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

    Constantine
    0

Add comment

Please sign in to leave a comment.