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