Capturing Target System Optimizer Cost Values and Dynamic AMP Statistical Samples - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Process Phases

The extraction of Optimizer cost value information from a target system and its subsequent application to a test system is a two-phase process, as follows.

1 Data capture phase.

Target system optimizer variables are read from the Dictionary and various system tables and written to a staging area. This phase is initiated from the target system.

2 Application phase.

The captured data in the staging area is exported to the appropriate Dictionary and system tables on the test system. This phase can be initiated from either the target or the test system.

You can use the Teradata System Emulation Tool from a client system to perform this data capture and application. See Teradata System Emulation Tool User Guide for details.

If you do not use Teradata System Emulation Tool, then you must follow a more circuitous path to capture target system optimizer variables and apply them to a test system. This topic presents both procedures.