This course focuses on Teradata indexing techniques.
In this two-hour video, you will learn about Teradata’s architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes.
You will gain the comprehensive knowledge required to create an ideal indexing landscape in your data warehouse setup.
Related Services
⚡ Need Help Optimizing Your Data Platform?
We cut data platform costs by 30–60% without hardware changes. 25+ years of hands-on tuning experience.
Explore Our Services →📋 Considering a Move From Teradata?
Get a personalized migration roadmap in 2 minutes. We have migrated billions of rows from Teradata to Snowflake, Databricks, and more.
Free Migration Assessment →
Hi, if you are on Teradata >= 14.00 you can try:
SELECT ASCII(‘A’);
->> Returns the decimal representation of the first character in string_expr as a NUMBER value.