Teradata ALTER Table versus INSERT INTO Altering the structure of a substantial Teradata table can consume significant resources. Essentially, there are two approaches: altering the DDL through Teradata ALTER TABLE or generating an empty table with t...
Teradata introduced several new features, including one that caught our attention: object use counts (OUC). This feature optimizes the calculation of extrapolated statistics, improving query performance significantly. Before version 13.10, changes ma...
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: The data is evenly distributed. To demonstrate the query’s selectivity for the te...
To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: As you know, a hashing al...
How to Abort the Teradata Rollback Executing a DML statement on a sizable table may trigger a prolonged ROLLBACK. In such cases, you must choose between waiting for the ROLLBACK to complete or terminating it. Cancelling a rollback avoids wasting addi...
Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is sig...
Access the Amazon Redshift Documentation here: https://aws.amazon.com/de/redshift/ Access the Amazon Redshift Documentation here: https://aws.amazon.com/de/redshift/
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 frequen...
Teradata transitioned to the cloud to prevent disconnection from contemporary cloud-based databases. I will demonstrate the Teradata Cloud solution in AWS and its resolutions for crucial aspects such as security, backups, and sizing. Teradata transit...
Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be promptly processed. Although SSDs are now predominantly used instead of hard disks, copying data into the main memory remains the s...