Teradata Query Performance Tuning: DWHPro's Guide

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. In this Teradata book, we share 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 Teradata 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.

Author: Artemios Vogiatzis, Roland Wenzlofsky
Publisher: Independently Published
Published: 10/18/2020
Pages: 208
Binding Type: Paperback
Weight: 0.93lbs
Size: 10.00h x 7.99w x 0.44d
ISBN13: 9798674853954
BISAC Categories:
- Computers | Data Science | Data Warehousing

This title is not returnable