16.10 - Autostats Enhancements - Teradata Database

Teradata Database Release Summary

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Release Notes
featnum
B035-1098-161K

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 Analzye 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® Database Application Programming Reference.