Book Image

Teradata Cookbook

By : Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati
Book Image

Teradata Cookbook

By: Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.
Table of Contents (19 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Archiving PPI tables


Teradata provides various indexing mechanisms, and Partitioned Primary Index (PPI) is one of them. PPU tables are useful in improving the performance of queries that utilize range-based data. It helps to restrict data retrieval to the partitions in which rows are present. In normal cases, rows are inserted into a table, they are stored in an AMP, and arranged by their row hash order. With the table defined with PPI, the rows are sorted by their partition number and are stored in a collective manner in their partitions. Within each partition, they are arranged by their row hash. Rows are assigned to a partition based on the partition expression defined.

Teradata provides two types of partitions on tables as show in the following figure:

  • Row level partition
  • Column level partition

You can perform an all-AMPs archive on one or more partitions of a table rather than performing a full-table backup. The ability to select partitions from PPI tables is limited to all-AMP archives...