Prerequisites - Visual Explain

Prerequisites

To run Teradata Visual Explain:

Establish the appropriate Teradata Visual Explain rights on Teradata Database.

For more information, see “Using the Administrative Functions” on page 94.

Increase the DBS Control Record MaxParseTreeSegs performance value to a higher limit to analyze complex queries.

For example, increase the value to 1500 (or 3000 for 64-bit systems). MaxParseTreeSegs define the number of 64‑KB tree memory segments the parser allocates when parsing a Teradata SQL statement. The valid range of values for MaxParseTreeSegs is 12 to 3000 (6000 for 64‑bit systems).

For information on setting DBS Control fields to help ensure that Teradata Database operates at peak performance based on applications and processing needs, refer to Utilities B035-1102.