This presentation builds on Recorded Webcast # 49911 Explaining the EXPLAIN, which did just that (if you have not viewed, please do so before watching this webcast).

Now, having completed that course, you should already have familiarity with the following Teradata EXPLAIN Facility features: how and where the text is generated; how to read the output; what spool sizes and estimated time (cost) really represent; choices that can be made to affect the optimizer; confidence levels; and joins.

In this session, we cover new features available in TD 14 and TD 14.10, including what to look for when accessing a columnar table, Incremental Query Processing (IPE) and the Partial Redistribution Partial Duplication join strategy for skewed data.

Presenter: Alison Torres, Director, Teradata Labs Customer Briefing Team - Teradata Coroporation

 

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:51203
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Price:$195.00
Credit hours:1.50