Sign in Subscribe

SQL

A collection of 180 issues

Enhancing Your Teradata Vantage Design with Teradata Historisation: A Comprehensive Method

Situation and Setup of a Historisation in Teradata Vantage Imagine that the time has come to improve your physical data model. Flawed or obsolete Teradata Vantage historisation design decisions need to be corrected. You are asked to separate tables of the same entity with different attributes. We do not question

Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)

Optimizing Teradata Queries: From No Index to Hashed NUSI

Teradata Rollbacks: Understanding the Impact on Performance and How to Avoid Them

What is a Teradata Rollback?A rollback reverses an incomplete transaction. Transactions can be unfinished for various reasons, such as user termination or database restart. Rollback ensures database integrity and is an essential aspect of an RDBMS. Rollbacks are implemented in Teradata using the DBC.TransientJournal table. A Before Image

Customize Your Redshift Workload Management System for Optimal Performance

Customize Workload Management Workload management in Redshift means optimizing the queues. This includes the correct selection of queues, the assignment of queries, and the allocation of memory. Although automated workload management and concurrency scaling have greatly improved workload management, workload management is a critical point in ensuring a scalable system

Teradata Transactions: Main Characteristics and Best Practices

Optimize Teradata UNION ALL with a Single Table Scan Trick

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

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

Teradata Access Paths: 8 Essential Ones to Know

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is