Primary & Partitioned Indexes

Teradata 14
  • 8 Videos | 57m 14s
  • Includes Assessment
  • Earns a Badge
Likes 2 Likes 2
Teradata databases use indexes to store and access rows of data from tables. Discover how to create the various primary and partitioned indexes used by Teradata.

WHAT YOU WILL LEARN

  • describe how indexes are defined and used in Teradata
    identify the different types of indexes that can be used in Teradata
    describe the different types of primary indexes, UPI, NUPI, used in Teradata and how data is processed with the index
    describe a NoPI object in Teradata and when it is used, and its benefits
  • describe PPI, and their advantages and disadvantages
    create the different types of primary indexes in Teradata
    partition tables using NoPI and PPI in Teradata
    describe and create column partitioning on Teradata tables

IN THIS COURSE

  • Playable
    1. 
    Overview of Indexes in Teradata
    8m 10s
    UP NEXT
  • Playable
    2. 
    Overview of the Types of Indexes
    11m 30s
  • Locked
    3. 
    Primary Indexes
    5m 42s
  • Locked
    4. 
    NoPI Objects
    4m 10s
  • Locked
    5. 
    Partitioned Primary Index
    7m 59s
  • Locked
    6. 
    Creating Primary Indexes
    3m 45s
  • Locked
    7. 
    Partitioning Tables
    6m 21s
  • Locked
    8. 
    Column Partitioned Tables
    5m 37s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 12 Likes 12  
Likes 11 Likes 11  
Likes 7 Likes 7  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 19 Likes 19  
Likes 3 Likes 3