Administration
A collection of 61 issues
Maximizing Performance with Multiple Teradata Sessions
Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.
Teradata Query Parallelism
A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data.
Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high
Warning: Teradata 16.20 Upgrade May Affect Reporting Queries - Potential Fix Found
How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study
The Optimizer typically excels in utilizing statistics, yet examining the execution plan and cardinality estimations can sometimes be beneficial.
Since Teradata 14.10, I have habitually included the SHOW STATISTICS statement in my considerations. The resulting metrics can aid in identifying statistical issues.
Teradata Statistics - Avoid the Heuristics
This
Teradata Priority Scheduler and Resource Allocation Rules
Learn about Teradata's priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table
As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights.
If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly.
1.
Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management
Learn why you should opt for DELETE instead of DROP when it comes to Teradata DDL. Avoid locking dictionary tables and conserve resources.
Teradata Locking Logger: How to Enable and Analyze Lock Activity
How to Join Partitioned Tables with an Unusual Trick for Improved Performance
Learn an unusual trick to improve the performance of joining partitioned tables with different primary indexes or partitioning. Read on to find out more.