Aster is an analytic discovery application that lets you perform exploratory queries across your data regardless if it is structured or not.

But have you ever wondered what goes on under the covers? Me too.

This fast-paced presentation covers:

  • The difference between an Explain Plan and Execution Plan
  • The Cost-based and the Rules-based plans
  • What is Inter-Cluster Express (ICE)
  • What is/is not considered a Shuffle
  • How to interpret the Cost value
  • Logical partitioned table versus non-Logical partitioned table Explain Plans
  • How to recognize and minimize Skew using Explain Plans
  • Comparing Row vs Columnar table Explain Plans
  • Comparing Compressed vs Non-Compress Explain Plans
  • How to drop hints in your query to change the Join type

 Note: Presented at the 2015 Teradata Partners Conference

Presenter: Jarrod Johnson - 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:54309
Training URL:http://www.teradata.com/t/ten/
Format:Recorded webcast
Price:$195.00
Credit hours:1.00