This session provides information on the basic concepts of Partitioned Primary Indexes.

What is a partitioned primary index? How do you define a partitioned primary index (PPI)? What are the RANGE_N and CASE_N functions all about? Get the answers and more about this performance enhancing capability during this presentation on the basics of partitioned primary indexes. This topic is of particular interest to physical database designers and database performance analysts. This session describes the newer partitioning capabilities such as multi-level partitioning, character PPI enhancements (13.10), ALTER TABLE TO CURRENT (13.10), and the increased number of partitions in Teradata 14.0. This session provides numerous DDL examples of creating partitioned tables using the newest features.

Key Points:

  • Understand the structure of a partitioned primary index and how it is implemented

  • Learn how to create and alter a PPI using various functions such as RANGE_N

  • Understand the advantages and disadvantages of using a partitioned primary index

Presenter: Larry Carter, Senior Learning Consultant – 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.
Course number:38855
Training URL:
Format:Recorded webcast
Credit hours:1.00