Prerequisites

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

To run Teradata Visual Explain do the following:

  • Establish the appropriate Teradata Visual Explain rights on Teradata Database.

    For more information, see Using the Administrative Functions.

  • 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).