Learn about Teradata’s column-orientated storage, which offers an alternative way of laying out data on disks, benefiting data retrieval in Big Data times. This article explains how columnar tables work, how they differ from row-oriented databases, and how you can create them in Teradata 14.00.
Discover how Map Reduce is becoming a key feature of most database vendors’ RDBMS. Follow an example of SQL aggregation statement joined with two tables.
This article presupposes your existing familiarity with the fundamental structure of a Teradata System. As you are aware, the AMPs operate on a Teradata System. The number of AMPs in charge of managing rows stored on their respective virtual disks varies based on the system’s size. There may be hundreds of AMPs. As noted in …
Learn how to clone tables in Teradata quickly and easily using the CREATE TABLE AS statement. Transfer statistics and definitions without wasting resources.
Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table’s statistics with a simple query.
What is the Teradata Explain Statement? Optimizing performance can be challenging, often requiring significant effort to identify the root issues. Thankfully, Teradata provides the EXPLAIN statement as a robust tool for assessing the execution of SQL statements. In Teradata, SQL statements are processed in a series of distinct tasks that correspond to specific components of …
Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.
Learn about the Teradata Join Index, a performance tuning tool that stores pre-joined tables, aggregations, or table content in a different structure. Discover its benefits, what it is used for, and when to use it.
Learn how to handle errors in Teradata Stored Procedures. Error handlers provide event-driven functionality and make error handling more efficient.
Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Miami, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.