Secondary & Join Indexes

Teradata 14
  • 9 Videos | 51m 53s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
Teradata offers various types of indexes which can be used based on the type of data and how it is accessed by the users. Discover how to create the secondary and join indexes used by Teradata.

WHAT YOU WILL LEARN

  • describe secondary index use in a Teradata Database
    describe data accessing using USI and NUSI in Teradata databases
    create USI and NUSI in Teradata
    identify the different types of join indexes that can be used in Teradata
    identify when to use a join index in Teradata and their storage
  • create join indexes in Teradata
    use the EXPLAIN request modifiers to determine the usefulness of indexes in a Teradata database
    identify when and how a full-table scan is used to access data in Teradata tables
    identify SQL queries that will use an index or perform a full-table scan in Teradata

IN THIS COURSE

  • Playable
    1. 
    Types of Secondary Indexes
    8m 4s
    UP NEXT
  • Playable
    2. 
    Data Access with Secondary Indexes
    4m 17s
  • Locked
    3. 
    Creating Secondary Indexes
    3m 6s
  • Locked
    4. 
    Types of Join Indexes
    5m 51s
  • Locked
    5. 
    Uses and Storage of Join Indexes
    4m 20s
  • Locked
    6. 
    Creating Join Indexes
    6m 13s
  • Locked
    7. 
    Using EXPLAIN to Determine Index Usefulness
    3m 33s
  • Locked
    8. 
    Full-Table Scans
    4m 50s
  • Locked
    9. 
    Using Indexes or Full-Table Scans
    7m 9s

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

CHANNEL Teradata
Likes 37 Likes 37  
Likes 133 Likes 133