SQL
A collection of 180 issues
Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)
Optimizing Teradata Queries: From No Index to Hashed NUSI
The initial situation without any index
In this blog, I will demonstrate how to optimize a query using Teradata's tools.
We will begin with the following test scenario:
CREATE TABLE Orders
(
OrderId BIGINT NOT NULL,
CustomerId BIGINT NOT NULL,
Amount BIGINT
) PRIMARY INDEX (OrderId);
INSERT INTO Orders
SELECT
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
Teradata Transactions: Main Characteristics and Best Practices
What Are The Main Characteristics Of Transactions in Teradata?
What is a transaction?Transactions ensure data integrity.
All requests within a transaction must be successful. Otherwise, changes to database objects are not applied. It is an "all or nothing" principle.
What is the difference between Teradata Mode and
Optimize Teradata UNION ALL with a Single Table Scan Trick
The Idea Behind This Trick for Teradata UNION ALL
What if you need to apply a UNION ALL operation to distinct columns within a single table? Typically, the process would involve:
SELECT CloseDate FROM Customer
UNION ALL
SELECT OpenDate FROM Customer
;
The drawback of this method is that it scans
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