Have you ever been bewildered trying to tune complex Teradata queries that go on for pages and pages of EXPLAIN text?  This presentation goes beyond "Explain the Explain", to teach strategies and techniques for quickly deciphering the most expensive operations in your queries.  Taught by a 20+ year Teradata veteran, examples of real queries gathered from some of the largest production environments in the world are used.  This is advanced material covered at a quick pace.

Key Points:

  • What are the advantages/disadvantages of the different join types you see in an EXPLAIN?
  • Describes guiding principles/strategies to use when trying to understand large and complex plans.
  • How does tuning a tactical query differ from tuning a data-mining/analytic query?
  • Describes techniques for tuning a query when collecting statistics alone does not give you an optimal plan.

Note: This presentation is part of the Logical & Physical Data Modeling Series.

Since a variety of topics are crammed into a single session, it is strongly encouraged (but not required) that one already have taken the standard instructor-led courses on Teradata Physical Database Design and Physical Database Tuning as well as "Explain the Explain" (either instructor-led or web-based course) before attending this session.

Presenter: Stephen Molini, Principal Consultant - 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.

Audience: Those with a role of Database Administrator (DBA), Application Developer, Programmer, Performance Analyst, or Data Warehouse Architect.

Course number 49122
Training URL http://www.teradata.com/t/ten/
Format Recorded webcast
Price $195.00
Credit hours 1.50