Columnar with a primary index (PI) is supported in Teradata Database 15.10. But what are the caveats in using it?
This presentation discusses this new capability and the pitfalls to avoid.  In addition to columnar with a primary index or no primary index, columnar is supported with the new primary AMP index. This presentation discusses how a primary AMP index avoids some of the pitfalls of using columnar with a primary index while improving join and aggregate performance compared to having no primary index.
 
Presenter: Paul Sinclair, 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: Application Developer, Data Analyst, Database Administrator, Design/Architect

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