This session provides information on the basic concepts of No Primary Index (NoPI) tables.

What are the advantages of using a NoPI table and what are some of the common uses for a NoPI table? How do you define a NoPI? How are rows distributed in the system with SQL requests and with the TPT LOAD utility for tables without a primary index? This session includes information on how to define and use an NoPI table. Get the answers and more details about this performance-enhancing capability during this session. The mechanics of how NoPI tables are implemented as well as the features and limitations of this feature are described in this session. This topic is of particular interest to physical database designer and database performance analysts.

Updated and re-recorded in April 2015.

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.

Audience: Data Warehouse Administrators, Data Warehouse Architect/ Designers, and Data Warehouse Technical Specialists

Course number:45842
Training URL:
Format:Recorded webcast
Credit hours:1.00