16.20 - Autostats Enhancements - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

This features improves Analyzer performance by parsing and processing logged XML documents in parallel. These XML documents store statistics recommendations and usage data that are analyzed by Analyze Jobs.

Benefits

  • Parallel parsing is enabled by default from DIPSTATS.
  • This feature can be enabled or disabled on individual analyzer jobs.

Considerations

  • Spool space usage may increase for Analyze Jobs. It is recommended to increase spool space, operate on a shorter time period, or operate on a shorter portion of query log data.
  • If parallel parsing is not desired, the user must manually disable it. For example: UPDATE TDStats.DefaultsTbl SET DefaultValue = 'N' WHERE SettingName = 'Analyze_Parse_Parallel';

Additional Information

For more information on Autostats Enhancements, see Teradata Vantageā„¢ Application Programming Reference, B035-1090.