322 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
The Teradata Permanent Journal captures permanent table snapshots pre- and post-modifications. Prior to any changes, the original row duplicates are saved in the permanent journal table. This mirrors the behavior of the transient journal table, which stores BEFORE images of tables when a transaction begins. Journaling can be implemented at the table or database level. …
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 to create and use USI effectively, and why recent statistics and high selectivity are important factors to consider. Don’t miss out on this unique insight into Teradata indexing!
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.”
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 consider while running the query and get accurate results.
Learn about the Teradata parsing engine’s tasks and how it impacts overall system performance. Find out how to clean up the DBC. AccessRights table to improve parsing times in this informative article.
Discover the benefits of using a Teradata NESTED join strategy for economical data joining. Learn how to enable this feature and optimize query design.
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.
Learn about the challenges of Teradata Performance Optimization from an expert. Discover why fixing a poorly designed data model is critical to success.
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.
Discover how Map Reduce is becoming a key feature of most database vendors’ RDBMS. Follow an example of SQL aggregation statement joined with two tables.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.