This presentation follows a Teradata SQL query from its origin at the client through the components of the parsing engine (PE), dispatched execution steps through the BYNET, step execution and file system management in the access module processor (AMP), merge and sorting of the response through the BYNET to the PE, and returning the answer set to the client.

Exploration of optimizer decisions and key wording in EXPLAIN plans are highlighted throughout the journey.

This presentation will follow a Teradata SQL query from its origin at the client...

... through the components of the parsing engine (PE), dispatched execution steps through the BYNET, step execution and file system management in the access module processor (AMP), merge and sorting of the response through the BYNET to the PE, and returning the answer set to the client.

Exploration of optimizer decisions and key wording in EXPLAIN plans will be highlighted throughout the journey.

Teradata Release information: Teradata 12.0 and higher

Note: This was a 2011 Teradata Partners Conference session.

Presenter: Pat Alvarado, Sr. Solution Architect – Teradata
 

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: Data Warehouse Administrator, Data Warehouse Application Specialist,Data Warehouse Architect/Designer

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