Tables without a Primary Index
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
Audience: Data Warehouse Administrators, Data Warehouse Architect/ Designers, and Data Warehouse Technical Specialists
Course number: | 45842 |
---|---|
Training URL: | http://www.teradata.com/t/ten/ |
Format: | Recorded webcast |
Price: | $195.00 |
Credit hours: | 1.00 |