Solving Rounding Issues in Teradata: A Possible Solution
Learn how to handle rounding issues in Teradata with this helpful article. Discover a possible solution to a common problem and improve your results!
Indexing
A collection of 141 issues
Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes
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 pl
A Comprehensive Guide to Teradata Volatile Tables
Learn about Teradata Volatile Tables, their features, restrictions, and performance tuning possibilities. Find answers to common questions about their usage.
Teradata Data Loss Protection: Transient Journal, Fallback, RAID 1, and Clique
Learn how Teradata protects your data against potential loss with its various features. Each feature offers unique protection on different levels.
Teradata Unique Secondary Index: Everything You Need to Know
Learn about Teradata's unique secondary indexes (USI) and how they provide an alternate access path to reduce disk IOs while retrieving data. This article explains the technical differences between USI and other indexes, and provides detailed information on the data retrieval process. Discover how t
A Brief History of Parallel Database Architectures and Their Limitations
Discover the history of parallel database architectures - from shared memory to shared disk and shared-nothing. Learn about the advantages and limitations of each architecture and how fault tolerance is handled. Explore the shift towards big data and the trend of "Hadoop over SQL."
How to get SQL Query Stats in Teradata
Learn how to determine SQL Query Performance in Teradata with these three essential parameters: AMPCPUTime, TotalIOCount, and SpoolUsage. Discover how to get SQL Query Stats and make the right decision for your queries using the DBC tables DBQLOGTBL and DBQLSQLTBL. Follow these three points to consi
The Teradata NESTED join and the impact of the Primary Index
Discover the benefits of using a Teradata NESTED join strategy for economical data joining. Learn how to enable this feature and optimize query design.
The Impact of Skewing on Teradata demonstrated
Learn how skewing on Teradata can impact query run times with this informative test scenario. Find key figures and observations to help optimize your performance.
Column-Oriented Storage in Teradata: A Solution for Big Data Challenges
Learn about Teradata's column-orientated storage, which offers an alternative way of laying out data on disks, benefiting data retrieval in Big Data times. This article explains how columnar tables work, how they differ from row-oriented databases, and how you can create them in Teradata 14.00.