Row Partitioning Archives

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

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

Illustration of three stacked database units of differing heights inside a circle

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 different 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. …

Teradata Columnar Solution: Advantages and Disadvantages

04/11/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 Popular

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of a network graph with circular nodes joined by lines

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 Popular

04/11/202604/21/2023 by Roland Wenzlofsky

Illustration of a glossy orange database cylinder with data fragments across its surface

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.