DWHPro Insights

Master Index

Teradata Physical Storage: Understanding the Technical Details for Performance Optimization Most read

Illustration of three stacked database units of differing heights inside a circle

A thorough understanding of the Teradata system’s technical intricacies is crucial to attaining expertise in performance optimization. Although many of us are knowledgeable about existing optimization opportunities, resolving complex performance issues often requires an in-depth understanding of internal data storage. The physical medium may be HDD, SSD or a cloud storage service, depending on deployment. …

Read more

Teradata Physical Storage: Exploring Data Blocks and Storage Demographics Widely read

Illustration of three stacked database units of differing heights inside a circle

This is a conceptual explanation with historical implementation examples. Logical cylinders and sectors do not imply mechanical disk geometry, and exact packing thresholds must be checked for the target release. It is not an instruction to run storage-maintenance utilities on a live system. Introduction to Teradata Physical Storage In the second part of this series …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam