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.