Teradata Cookbook电子书

Title Page

Copyright and Credits

Teradata Cookbook

Dedication

Packt Upsell

Why subscribe?

PacktPub.com

Contributors

About the authors

About the reviewer

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the example code files

Download the color images

Conventions used

Get in touch

Reviews

Installation

Setting up Teradata 15.10

How to do it...

Setting up Teradata Studio Express

Getting ready

How to do it...

Teradata on Azure

Getting ready

How to do it...

How it works...

There's more...

Defining a connection

How to do it...

Connecting to the Teradata system

How to do it...

There's more...

Using Studio tool options

Setting up Teradata SQLA

Getting ready

How to do it...

How it works...

There's more...

Configuring SQLA

Getting ready

How to do it...

How it works...

Building a query builder

How to do it...

Query builder in SQLA

Query builder in Express

Importing data

Getting started

How to do it...

In Express

Exporting data

How to do it

How it works...

There's more...

SQLs

Introduction

Writing queries

Getting ready

How to do it...

Using SQLA

Using BTEQ in Windows

How it works...

There's more...

Querying efficiently

Getting ready

How to do it...

How it works...

Explain before executing queries

Getting ready

How to do it...

How it works...

There's more...

Decoding explain

How to do it...

How it works...

There's more...

Resolving skewing data

Getting ready

How to do it...

How it works...

There's more...

See also

Resolving skew in database

Getting ready

How to do it...

How it works...

There's more...

Solving insert performance

Getting ready

How to do it...

How it works...

There's more...

Improving delete performance

Getting ready

How to do it...

How it works...

There's more...

Improving update performance

Getting ready

How to do it...

How it works...

There's more...

See also

Performing MERGE INTO

Getting ready

How to do it...

How it works...

Advanced SQL with Backup and Restore

Introduction

Backup and recovery

Exploring ordered analytic functions

Getting ready

How to do it...

How it works...

There's more...

Using CASE statements

Getting ready

How to do it...

How it works...

There's more...

Working with correlated subqueries

Getting ready

How to do it...

How it works...

There's more...

Experimenting with JSON

Getting ready

How to do it...

How it works...

There's more...

Partitioning tables column wise

Getting ready

How to do it...

How it works...

There's more...

Archiving data dictionary

Getting ready

How to do it...

How it works...

There's more...

Archiving databases

Getting ready

How to do it...

How it works...

There's more...

Archiving PPI tables

Getting ready

How to do it...

How it works...

There's more...

Restoring a table

Getting ready

How to do it...

How it works...

There's more...

Generating a unique row number

Getting ready

How to do it...

How it works...

There's more...

All about Indexes

Introduction

Creating a partitioned primary index to improve performance

Getting ready

How to do it...

How it works...

There's more...

Creating a join index to improve performance

Getting ready

How to do it...

How it works...

There's more...

Creating a secondary index to improve performance

Getting ready

How to do it...

How it works...

There's more...

Creating a hash index to improve performance

Getting ready

How to do it...

How it works...

There's more...

Mixing Strategies – Joining of Tables

Introduction

Identifying skewness in joins

Getting ready

How to do it...

How it works...

There's more...

Identify the right columns for joins

Getting ready

How to do it...

How it works...

There's more...

Eliminating product joins

Getting ready

How to do it...

How it works...

There's more...

See also

Improving left join

Getting ready

How to do it...

How it works...

Improving Teradata joins

Getting ready

How to do it...

How it works...

Building Loading Utility – Replication and Loading

Introduction

Loading data from flat to Teradata

Getting ready

How to do it...

How it works...

There's more...

Resolving FastLoad error 2652

Getting ready

How to do it...

How it works...

There's more...

Using MultiLoad to delete

Getting ready

How to do it...

How it works...

There's more...

Resolving MLOAD error 2571

Getting ready

How to do it...

How it works...

There's more...

Resolving failure 7547

Getting ready

How to do it...

How it works...

There's more...

Upserting data using MLOAD

Getting ready

How to do it...

How it works...

There's more...

Loading data from a one Teradata Database to another

Getting ready

How to do it...

How it works...

Monitoring the better way

Introduction

Configuring the viewpoint portlet

Getting ready

How to do it...

How it works...

Identifying killer queries in viewpoint

Getting ready

How to do it...

How it works...

There's more...

Setting up viewpoint alerts

Getting ready

How to do it...

How it works...

There's more...

Changing and managing filters

Getting ready

How to do it...

How it works...

There's more...

Changing and managing throttle

Getting ready

How to do it...

How it works...

There's more...

Defining a ruleset

Getting ready

How to do it...

How it works...

Creating a TASM exception

Getting ready

How to do it...

How it works...

Collect Statistics the Better Way

Introduction

Cost-based optimizer

Evolution of statistics

How to collect statistics

Getting ready

How to do it...

How it works...

Identifying stats for a table

Getting ready

How to do it...

How it works...

There's more...

Identifying multi-column stats

Getting ready

How to do it...

How it works...

There's more...

How to collect expression stats

Getting ready

How to do it...

How it works...

There's more...

How to copy statistics

Getting ready

How to do it...

How it works...

There's more...

Using help and show to resolve query issues

Getting ready

How to do it...

How it works...

There's more...

Recommendations

Application and OPS DBA Insight

Introduction

Creating, copying, and dropping tables

Getting ready

How to do it...

How it works...

There's more...

Working with views

Getting ready

How to do it...

How it works...

There's more...

Defining workloads based on application

Getting ready

How to do it...

How it works...

There's more...

Securing passwords using Teradata Wallet

Getting ready

How to do it...

How it works...

There's more...

Shrinking your data size

Getting ready

How to do it...

How it works...

There's more...

Using query band

Getting ready

How to do it...

How it works...

DBA Insight

Introduction

Creating a Teradata database

Getting ready

How to do it...

How it works...

There's more...

Creating a Teradata database user

Getting ready

How to do it...

How it works...

There's more...

Creating profiles and assigning them to users

Getting ready

How to do it...

How it works...

There's more...

Creating a Secure Zone

Getting ready

How to do it...

How it works...

There's more...

Creating user accounts

Getting ready

How to do it...

How it works...

Investigating phantom and leftover spool issues

Getting ready

How to do it...

How it works...

There's more...

Unlocking archive HUT locks

Getting ready

How to do it...

How it works...

There's more...

Performance Tuning

Introduction

Resolving a slow or hung system

Getting ready

How to do it...

How it works...

Monitoring slow queries

Getting ready

How to do it...

How it works...

There's more...

Aborting a session from the supervisor window

Getting ready

How to do it...

How it works...

There's more...

Resolving AWT saturation

Getting ready

How to do it...

How it works...

There's more...

Identifying suspect queries

Getting ready

How to do it...

How it works...

Managing DBC space

Getting ready

How to do it...

How it works...

There's more...

See also

Optimizing queries

Getting ready

How to do it...

How it works...

See also

Troubleshooting

Introduction

Restarting the TD system

Getting ready

How to do it...

How it works...

There's more...

Insufficient memory to parse this request

Getting ready

How to do it...

How it works...

There's more...

Recovering AMP down

Getting ready

How to do it...

How it works...

There's more...

Performing scandisk on the system

Getting ready

How to do it...

How it works...

There's more...

Unlocking the DBC

Getting ready

How to do it...

How it works...

There's more...

Managing the FSG cache

Getting ready

How to do it...

How it works...

There's more...

Other Books You May Enjoy

Leave a review - let other readers know what you think