Automated Statistics Management
Managing Teradata Optimizer statistics can be labor intensive and error prone. Many users struggle to know what columns and indexes to collect statistics on, how to detect and prevent statistics from becoming stale, and how to know if collected statistics are being used.
Enter AutoStats! Automated Statistics Management (or AutoStats for short) is a new feature in Teradata 14.10 that helps automate statistics collection and provides intelligence surrounding statistics management. Using the new “Stats Manager” portlet in Teradata Viewpoint 14.10, users can schedule jobs to collect statistics and analyze a system for missing, stale, and unused statistics. Join us for a demo of the new “Stats Manager” portlet in Teradata Viewpoint and learn what AutoStats can do for you! The session includes discussions on best practices and how AutoStats works behind the scenes.Presenters:
Eric Scheie - Teradata Corporation
Louis Burger - Teradata Corporation
Course number: | 51253 |
---|---|
Training URL: | http://www.teradata.com/t/ten/ |
Format: | Recorded webcast |
Price: | $195.00 |
Credit hours: | 1.50 |