fbpx
Teradata Book Query Performance Tuning
Teradata Book Query Performance Tuning

Become a Teradata Expert!

Teradata is one of the most sophisticated, high-performance database systems for the data warehouse sector. But as with all shared-nothing, massively parallel processing systems, it is necessary to use the available resources to efficiently achieve optimal performance.

This Teradata book shares over 25 years of knowledge and experience in SQL tuning. We describe in a simple and comprehensible way all the information that must be considered when one is called to improve anything from a single badly-performing query up to the entire DWH workload of overnight batch processes failing to meet the service level agreements.

The book follows the full lifecycle of a Teradata DWH, from the architecture and design to optimizing data access paths and execution plans. Anyone involved in the development, administration, or database design will benefit from the tips and tricks presented in this book.

About the Authors

Roland Wenzlofsky

Roland Wenzlofsky

Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer ("Teradata Certified Master"). Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. He has played all the roles of developer, designer, business analyst, and project manager. Therefore, he knows like no other the problems and obstacles that make data warehouse projects fail and all the tricks and tips that will help you succeed.

Roland is the DWHPro www.dwhpro.com founder and lead contributor. DWHPro provides in-depth information about the Teradata system and data warehousing in general, helping thousands of visitors every month to become real experts.

Artemios Vogiatzis

Artemios Vogiatzis

Artemios Vogiatzis is a seasoned IT professional with rich experience in distributed, international, and interdisciplinary environments, both in academic and business worlds. Since 2017, he optimizes data pipelines to Teradata-based DWH for the leading bank in Austria. Among others, he is a Teradata Vantage Certified Developer and Professional Scrum Master (PSM I). His academic credentials include a B.Sc. in Mathematics, a B.Sc. and an M.Sc. in Computer Science, and a Ph.D. in Computer Engineering.

Teradata Book Query Performance Tuning
Teradata Book Query Performance Tuning

Become a Teradata Expert!

Teradata is one of the most sophisticated, high-performance database systems for the data warehouse sector. But as with all shared-nothing, massively parallel processing systems, it is necessary to use the available resources to efficiently achieve optimal performance.

This Teradata book shares over 25 years of knowledge and experience in SQL tuning. We describe in a simple and comprehensible way all the information that must be considered when one is called to improve anything from a single badly-performing query up to the entire DWH workload of overnight batch processes failing to meet the service level agreements.

The book follows the full lifecycle of a Teradata DWH, from the architecture and design to optimizing data access paths and execution plans. Anyone involved in the development, administration, or database design will benefit from the tips and tricks presented in this book.

>