Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?

Wouldn't it be nice if something could dynamically collect and drop stats? Database Query Log (DBQL) is essential for bringing the new AutoStats feature to life in Teradata 14.10. It also enables new capability to log utility job statistics in Teradata 15.0. DBQL is the key tool to drive query performance analysis and workload management setup and adjustments. In this presentation, we discuss the basics of DBQL, review DBQL enhancements, discuss query performance metrics and review how to trend performance data. We help you understand how to prioritize optimization efforts and ensure resources are assigned to the proper workload definitions. To get the most out of your DBQL data, make sure you are completely informed and up-to-date to ensure faster problem solving and performance optimization.

Presenters:  Barbara Christjohn & Steven Tagai - Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.
Course number:52912
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Credit hours:1.50