Whether you write your own code or it is generated for you, this is a topic that is essential for business users who run SQL queries.

This session examines the English text that appears when an EXPLAIN is requested and why it is useful in your environment. You will learn what the Optimizer EXPLAIN Facility is, where the text is generated, how to read the EXPLAIN output, and what spool sizes and estimated times really represent. We explore topics such as confidence levels, table scans, join preparation and processing including Merge, Exclusion and Product joins and multi-table joins, and the newest optimization features. At the end of this session you will be able to understand essential elements of the EXPLAIN and be able to use it to gain more value from your Teradata system and your queries.

Don’t miss this opportunity to learn about the value and usefulness of EXPLAIN in any Teradata environment.  

Through this course, you will learn about the EXPLAIN facility, where it is generated, key phrases, and how to read the output.

Key Points:

  • Inside a Teradata Node and what the VProcs do for your query
  • The EXPLAIN Facility syntax and what it means
  • EXPLAIN Examples
  • Teradata Visual EXPLAIN

Updated and re-recorded in 2015.

Presenter: Alison Torres, Director, Teradata Labs Customer Briefing Team – Teradata  Corporatio

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: Business users, especially those who write their own SQL

Course number:38085
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Credit hours:1.50