327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Introduction Teradata is a name synonymous with data warehousing and large-scale data analytics. Teradata has provided organizations with innovative solutions and technologies for over four decades as a pioneer in the field. This article will delve into the fascinating world of Teradata, exploring its history, architecture, and diverse applications. We will also address some common …
Learn how to connect Teradata SQL Assistant, export CSV files and troubleshoot client or driver issues. Database server installation does not imply that the desktop client is included.
Discover the power and unique features of Teradata SQL, the dialect of SQL used within Teradata’s large-scale data warehousing and analytics platform. Learn about its differences from standard SQL and how to run queries using Teradata SQL Assistant and BTEQ.
Learn how BTEQ runs SQL and transfers data, including binary DATA exports, import formats and script control flow. Compare ETL tools for the actual workload.
Learn how to work with Teradata OLAP Functions in your data warehouse applications. This systematic approach covers five key design decisions.
The Teradata Primary Index and Hash Collisions Primary-index data types, character sets and collations can materially affect hashing, comparison and join conversions. Choose types for correct business semantics and compatible joins; benchmark relevant access paths before changing them. This article addresses a performance issue with CHARACTER columns in the primary index. Although not as apparent …
Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.
Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.
Learn about the features and benefits of Teradata Identity Columns, and why they are used for transactional and bulk inserts. Discover the data types, syntax, and more.
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
Protected by Security by CleanTalk