Statistics about tables, columns and indexes are a critical component in producing good query plans.

This session examines the different options that are available when collecting statistics, with an emphasis on the new USING clauses and other enhancements in Teradata 14.0. Statistics histograms are detailed, and the important role that SUMMARY statistics play is emphasized. The improved statistics extrapolation process and the ability to combine statistics collections into a single table scan is also covered. The session wraps up with some general recommendations for statistics collection in Teradata 14.0.

Key Points:

  • Learn the differences between statistics collection approaches
  • Find out how the new Teradata 14.0 enhancement can benefit you
  • Understand the new statistics collection recommendations for 14.0

Teradata Release information: Teradata 14.0

Presenter: Carrie Ballinger, Software Engineer – 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: Data Warehouse Administrator, Data Warehouse Application Specialist; Data Warehouse Architect/Designer, Data Warehouse Technical Specialist

Course number:50654
Training URL:
Format:Recorded webcast
Credit hours:2.00