16.20 - Autostats Enhancements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)
Last Update
2019-05-03

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.