This is more than an overview of the Indexes that are available in Teradata and how they work.

Part One: We cover Primary Indexes: Unique and Non-Unique, Partitioned Primary Indexes, Multi-Level Partitioned Primary Indexes; Secondary Indexes: Unique, Non-unique, Single Table Join, Aggregate Join, Value Ordered, Sparse, and Hash Indexes; and some interesting ways to mix and match indexes to gain optimal access and performance.

Part Two: Continues the discussion of utilizing indexes in Teradata and provides numerous examples of using indexes to gain optimal access and performance. Examples of using Partitioning and Secondary Indexes with Join Indexes are provided. A discussion of creating and using NoPI (No Primary Index) tables is given as well as information on how NoPI tables are implemented (distribution and storage). This session summarizes various techniques to mix and match indexes to gain optimal access and performance.

Note: This was a 2010 Teradata Partners Conference session.

Alison Torres, Senior Consultant - Teradata Corporation
Larry Carter,  Senior Learning Consultant - 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:48502
Training URL:
Format:Recorded webcast
Credit hours:2.00