Row Partitioning Archives -

Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More

03/08/202605/05/2023 by Roland Wenzlofsky

This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms to understand their distinctions and overlaps, despite their disparate architectures. Clustered Index vs Teradata Row Partitioning The SQL Server’s clustered index arranges table rows in a specific physical order, making it ideal for range-based queries. …

Save Space with Teradata: Utilizing Block Level Compression and Row Partitioning

03/08/202605/02/2023 by Roland Wenzlofsky

The latest generation of Teradata systems always has Block Level Compression (BLC) enabled. When using MultiValue compression, the compression factor is typically low. How Block Level compression and MultiValue compression relate to each other is shown in detail in the article below: In this article, we will show you a trick on how to use …

Designing Teradata Row Partitioning for Optimal Performance in Tactical Workloads

03/08/202605/02/2023 by Roland Wenzlofsky

Teradata is commonly used for tactical workloads and OLTP applications in my projects. However, it is crucial to avoid designing the databases thoughtlessly. Teradata excels as a database for strategic data warehousing. High-performance queries can often be achieved without special design techniques. Keeping statistics current and correctly designing row partitioning is typically sufficient, while other …

Teradata Columnar Solution: Advantages and Disadvantages

03/08/202604/28/2023 by Roland Wenzlofsky

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …

Building a Teradata Data Warehouse: Considerations for ETL Process, SQL Queries, and Physical Data Model

03/08/202604/28/2023 by Roland Wenzlofsky

This post aims to compile all crucial aspects to be considered while constructing a Teradata Data Warehouse, including the ETL process and SQL queries. This list is just the beginning, and I anticipate receiving valuable feedback from my readers to expand it in the future. Initially, I have provided a few concepts, but I intend …

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes

03/08/202604/21/2023 by Roland Wenzlofsky

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.