Key Benefits - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata SET imitates a target (production) system on a test system. System-level environmental data is captured from the target system, then stored in relational tables. The Teradata Query Optimizer (Optimizer) processes information from these tables, together with appropriate column and index statistics, to generate query plans on the test system as though the operation occurred in the production environment.

Use Teradata SET to do the following:
  • Imitate the impact of environmental changes on Structured Query Language (SQL) statement performance.
  • Determine the source of Optimizer-based query issues using imported environmental cost data and random AMP sample (RAS)-based statistical data.
Teradata SET performs the following key functions:
  • Works as a standalone application.
  • Interfaces with a Teradata Database using CLIv2 or ODBC.
  • Exports system information from a target system to a specified file on a workstation.
  • Imports system information from the workstation to a test system.
  • Displays the Query, Explain Text, Step Report, and Summary Information for queries in the Import window.
  • Allows editing of object definitions, statistics, RAS, cost parameters, and cost profiles before import to a test system.
  • Exports and imports data demographics of tables from one Query Capture Database (QCD) to another.
  • Provides a summary report of the failures and successes of an import, export, or undo (cleanup) operation.
  • Allows visual reordering of databases.
  • Exports and imports workload recommendations.
  • Allows other client applications to use Teradata SET functions.