Secondary & Join Indexes

Teradata 14    |    Beginner
  • 9 videos | 47m 23s
  • Includes Assessment
  • Earns a Badge
Rating 4.0 of 1 users Rating 4.0 of 1 users (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

  • 8m 4s
    After completing this video, you will be able to describe the use of secondary indexes in a Teradata Database. FREE ACCESS
  • 4m 17s
    Upon completion of this video, you will be able to describe data accessing using USI and NUSI in Teradata databases. FREE ACCESS
  • Locked
    3.  Creating Secondary Indexes
    3m 6s
    In this video, find out how to create a USI and NUSI in Teradata. FREE ACCESS
  • Locked
    4.  Types of Join Indexes
    5m 51s
    Find out how to identify the different types of join indexes that can be used in Teradata. FREE ACCESS
  • Locked
    5.  Uses and Storage of Join Indexes
    4m 20s
    In this video, you will learn how to identify when to use a join index in Teradata and how they are stored. FREE ACCESS
  • Locked
    6.  Creating Join Indexes
    6m 13s
    In this video, you will learn how to create join indexes in Teradata. FREE ACCESS
  • Locked
    7.  Using EXPLAIN to Determine Index Usefulness
    3m 33s
    In this video, you will learn how to use the EXPLAIN request modifiers to determine the usefulness of indexes in a Teradata database. FREE ACCESS
  • Locked
    8.  Full-Table Scans
    4m 50s
    In this video, you will identify when and how a full-table scan is used to access data in Teradata tables. FREE ACCESS
  • Locked
    9.  Using Indexes or Full-Table Scans
    7m 9s
    In this video, you will learn how to identify SQL queries that will use an index or perform a full table scan in Teradata. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Database Core Concepts
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Channel Interskill VSAM