Organize a rule tree to minimize the impact of Dynamic Data Masking on the target database. An efficient rule tree reduces the number of rules that the Rule Engine must apply and defines an organizational structure that leverages the best use of the rule components.
Use the following guidelines to create an efficient rule tree:
Use text matchers for all incoming connections to ensure a faster response time. Text matchers take approximately one microsecond per request.
Minimize the use of syntax matchers. Syntax matchers parse SQL request that Dynamic Data Masking listener port receives. A syntax matcher can take over 100 microseconds to process.
Configure the matcher to keep the matcher result valid for all concurrent SQL requests that are open in a session. The default time that the Rule Engine stores matcher results is 3,600 seconds.