Sign in Subscribe

Indexing

A collection of 141 issues

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. * Primary Index or NOPI? * Is the Primary Index distributing rows evenly? * Is the correct character set used? * Are character sets and data types matching across tables? * Can the Primary Index be

Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.

Teradata Query Parallelism A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data. Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high

The Importance of Teradata Surrogate Keys

What are Teradata Surrogate Keys? A Teradata Surrogate Key is an artificial key that maps to a natural key. It is usually of the data type INTEGER or BIGINT and is represented by a single column. The natural key can consist of multiple columns. The surrogate key is generated automatically

Advanced GROUPING Methods in Teradata SQL: GROUP BY GROUPING SETS, ROLLUP, and CUBE

Teradata SQL and Advanced GROUPING Functions What advanced GROUPING methods are there in Teradata SQL?- GROUP BY GROUPING SETS - GROUP BY ROLLUP - GROUP BY CUBE What is GROUP BY CUBE used for?One or more columns are used to group across multiple dimensions. If grouped by n

Achieve Incredible Teradata Join Performance

How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study

Optimizing Teradata Requests with Group-AMP Operations for Improved Performance

How to Find ASCII Code of a Character Using Teradata SQL

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

Learn Teradata Indexing Techniques in this 2-Hour Video Course

Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table

As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights. If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly. 1.